Page History

...

1. Select the standard postgres database and right click on it.
2. In the context menu, click on the Query Tool item.
   
   A field for entering the SQL code will open 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 .
   
   After that, you will see a message that the pgs database has been created.
   
5. To see it, right-click on the Databases node and select Refresh... in the context menu.
   
   The list will be updated and the created database will appear.
6. By default, the database is inactive, so its icon is grayed out .
   To connect to it, just click on it and open its node.
   
7. Create users to work with the database:
   • Select the created pgs database and right-click on it
   • In the context menu, 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 user with full access to the pgs database and the right to create roles.

8. To test the user creation 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:
   

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