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 ...

Instructions for installing Azure Data Studio

 Instructions for installing Azure Data Studio



To start installing Azure Data Studio, you need to run the setup file you downloaded earlier - azuredatastudio-windows-setup


This will open the installer. You must first accept the terms of the license agreement. Click "I accept the terms of the agreement" and then "Next".


1


On the next window, we will be prompted to change the installation folder, you can leave it by default. We press "Next".



The note! TOP 5 popular database management systems (DBMS).

2

Then there are the settings for displaying shortcuts in the start menu. We can leave everything at default again. We press "Next".


 3


Here we are offered to perform additional tasks, for example, create a shortcut on the desktop. Put the necessary checkboxes and click "Next".


 4


Everything is ready for installation, click "Install".


SQL course for beginners


 5


The installation will take literally a minute, and when the following window is displayed, the installation will be completed.


To start Azure Data Studio immediately, check the "Start Azure Data Studio" checkbox and click "Finish".


 6


The note! Overview of tools for working with Microsoft SQL Server.


On the desktop and in the start menu (if you made such settings during the installation process), the corresponding shortcuts to launch the Azure Data Studio program will appear.


7


The Azure Data Studio interface looks like this.