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

Access server - router

 Access server - router



This type of network is most often called routing, in which case the server performs the function of an Internet conductor with its own hands, it is dominated by the presence of several network cards (we will refer to network cards as INTERNET and LAN in the future). The home server itself is connected to the Internet via the INTERNET card, and the second LAN card is connected to the local network, where it is necessary to distribute the Internet. The task of the server itself in this case is to direct traffic to exactly those addresses of computers (clients) that need it. The access server can limit the capabilities of clients, for example, if we need to give Internet access only to certain computers, while others on the same network are used only as local ones. This feature of limiting the client's network capabilities is called a Firewall.

Access Server

Restrictions can be both in terms of speed and the permission of the client's access to the Internet. The simplest example is a complete ban on Internet access, it can also be partial access, limited at the port level, which means that you can separately prohibit Internet access not only for a computer, but also for a separate program on this computer. Like a computer, each program has its own address on the network. The computer address is commonly referred to as an IP address, while the address of a client program is commonly referred to as a port.