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 Opera browser on Windows?




We will install Opera on the Windows 8.1 operating system, so let's get started.

Step 1
Run the downloaded file. In the first window, we can immediately click on the "Accept and Install" button. In this case, the installation of the program will start with the default settings, but if you want to change some installation settings, such as the language or installation folder, then click the "Settings" button. Let's do it that way, i.e. Let's see what the settings are.


SQL course for beginners

Step 2
If necessary, change the desired parameter, then click the "Accept and install" button.



The installation has started.



Step 3
After the installation is completed, the browser will automatically launch with a welcome page. You can close the tab or click the "Get to work!" button, which will open the "Express Panel" with the popular sites already configured by default.




After you close the browser, you can restart it using a shortcut on the desktop or on the taskbar, and, of course, using the Start menu.