How to connect to PostgreSQL database using pgAdmin 4?

 How to connect to PostgreSQL database using pgAdmin 4? In order to set up a connection to the PostgreSQL database, run pgAdmin 4, for example, from the Start menu. As a result, pgAdmin 4 will start. Then click the menu "Object->Create->Server" or right-click on the item "Servers" and select "Create->Server". The server connection settings window will open. On the General tab, we invent and enter the name of our server in the Name field. On the Connection tab, enter the server IP address, username, password, and if you want, you can check the “Save password?” to save the password and not to enter it every time you connect. If the standard port (5432) of the PostgreSQL server has been changed, then you also need to change it here. Press the "Save" button. Note! The PostgreSQL server must be installed, configured and running. We considered an example of installing and configuring PostgreSQL DBMS on Linux Debian in the material “Installing ...

How to install pgAdmin 4 on Windows 7?

 How to install pgAdmin 4 on Windows 7?





On the Windows operating system, pgAdmin 4 is installed in the same way as any other application, this process is simple, but we will now consider it in detail anyway.

Note! In order to install pgAdmin 4, you need approximately 350 megabytes of free disk space.

Step 1
Run the downloaded file. On the welcome window, click Next.



Step 2
Then we agree to the terms of the license agreement, for this we mark the item "I accept the agreement" and click "Next".



Step 3
Then we can specify the path to the directory where the program will be installed, I leave it by default, click "Next".



The note! How to create a database in PostgreSQL using pgAdmin 4.

Step 4
Everything is ready for installation, click "Install".


SQL course for beginners

The installation has started.



Step 5
The installation will be completed, after the following window appears, click "Finish" (if the "Launch pgAdmin 4" checkbox is checked, then after clicking the "Finish" button, the pgAdmin 4 program will start).

Screenshot 9