Page History

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

...

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 We used a 64-bit platform, therefore, in this guide, we chose downloaded the version for Windows x86-64.
   Image Added
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 of no importance unless there are specific reasons for the change.
   • Specify the database components.
     All the components 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 usersuperuser.
     For example: , postgres.
   • Select the port for the installed PostgreSQL server copy to be installed.
     DefaultBy default: 5432.
   • Select the database localization of the database. By default, this it 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 them and start the installation.
5. Stack Builder doesn't There is no need to run Stack Builder yet. Uncheck the box and click Finish.
   Image Added

Starting pgAdmin

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

...

1. Select the standard postgres database and right click on it.
2. In the context menu that appears, click on the Query Tool item.
   In the central part of the program, a
   Image Added
   A field for entering the SQL code will openopen in the central part of the program.

3. In this field, enter the following code with the name of the new database:

   Code Block
   language sql
   create database pgs;

   
   

4. Click on the execute code button Image Added.
   Image Added
   After that, you will see a message will appear stating that the pgs database has been created.
   Image Added
5. To see it, right-click on the Databases node and select Refresh... from in the context menu.
   Image Added
   The update list will take place be updated and the created database will appear in the list.
6. By default, the database is inactive, so its icon is grayed out Image Added.
   To connect to it, just click on it and open its node.
   Image Added
7. Create users to work with the database:
   • Select the created pgs database and right-click on it
   .
   • In the context menu
   that appears
   • , click on the Query Tool item
   .
   • Enter the following code:

     Code Block
     language sql
     create user username password 'pgspgs';

   
   

   • grant all on database pgs to username;

   
   

   • alter user username with createrole;

     This will create a username

   username

   • user with full access to the pgs database and the

   ability

   • right to create roles.

8. To test the user creation

   of a user

   in pgAdmin 4, type the following command in the Query Tool:

   Code Block
   language sql
   select *

   
   

   from pg_shadow

   A list of all users will appear:
   Image Added

9. When closing pgAdmin 4, save your changes to the existing or new folder.
   Image Added
10. Go to the instructions for configuring setting up r_keeper communication connection with PostgreSQL database.

...