Installing PostgreSQL on Windows

This article is about installing PostgreSQL. Configuring communication with r_keeper 7 is described in a separate article.

Installing PostgreSQL

1. Download the installer from the website: https://www.postgresql.org/download/windows/
   At the time of this writing, the latest version of the PostgreSQL database is 13.3. During the installation process, we used a 64-bit platform, therefore, in this guide, we chose the version for Windows x86-64.
2. Run the .exe file and walk through the basic installation steps.
   Almost all steps already have pre-filled values. They do not need to be changed unless necessary:
   • Specify the installation path.
     The location of the server is irrelevant unless there are specific reasons for the change.
   • Specify the database components.
     All are selected by default.
   • Choose a path for the stored data.
     The location of the database doesn't matter either.
   • Choose a password for the postgres super user.
     For example: postgres.
   • Select the port for the PostgreSQL server copy to be installed.
     Default: 5432.
   • Select the localization of the database. By default, this is just the Default locale.
     In the future, when using Unicode, the localization will not matter for the stored data. But the names depend on the localization, for example, the days of the week and months.
3. The installer will offer to look at the selected parameters.
4. Check and start installation.
5. Stack Builder doesn't need to run yet. Uncheck the box and click Finish.

Starting pgAdmin

1. In the PostgreSQL 13 folder, select and run the pgAdmin 4 application.
2. A launch window will open.
3. Set a password for the admin panel, for example postgres.
4. Click on the OK button.
   It will connect to the server using the password specified during installation. Then one pre-installed postgres database will appear.
5. Create your database.

Database creation

1. Select the standard postgres database and right click on it.
2. In the menu that appears, click on the Query Tool item.
   In the central part of the program, a field for entering the SQL code will open.
3. In this field, enter the following code with the name of the new database:
4. create database pgs;
   Click on the execute code button.
5. After that, a message will appear stating that the pgs database has been created.
6. To see it, right-click on the Databases node and select Refresh ... from the context menu.
7. The update will take place and the created database will appear in the list.
   By default, the database is inactive, so its icon is grayed out.
   To connect to it, just click on it and open its node.
8. Create users to work with the database:
   Select the created pgs database and right click on it.
   In the menu that appears, click on the Query Tool item.
9. Enter the following code:
10. create user username password 'pgspgs';
    grant all on database pgs to username;
    alter user username with createrole;
    This will create a username username with full access to the pgs database and the ability to create roles.
11. To test the creation of a user in pgAdmin 4, type the command in the Query Tool:
12. select *
    from pg_shadow
    A list of all users will appear:
13. 
    When closing pgAdmin 4, save your changes to the existing or new folder.
14. Go to the instructions for configuring r_keeper communication with PostgreSQL database.