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

Mini server

 Mini server


A server is a part of a computer network for sharing resources. For a beginner, the main thing is to understand how and why the server will be used. After all, it is with this idea that the assembly, installation and configuration of the server begins. Server creation steps:


- choice of components

- selection and installation of the operating system

- network configuration

- setting up application programs



Mini server - the conventional name of the server based on a simple personal computer, it's easier to say it's a home server, and its role can be played by both a simple desktop computer and a nettop, laptop and even a netbook. The main goal of mini server is to show the maximum possibilities of mini systems, both in terms of equipment cost and performance. A do-it-yourself server is not inferior in quality to many hosting companies and even surpasses some companies in many ways.


Why do you need a server - first of all, the server is needed for organizing and teamwork on the network. As the basis for mini server, I have identified several types of servers:


- Game server

- Web server

- File server

- Access Server


To ensure the correct operation of the equipment, it is also necessary to include an uninterruptible power supply (UPS) in the server infrastructure. For small servers, a line-interactive (Smart) UPS is suitable. When choosing an uninterruptible power supply for a server, you should pay attention to the "flagship" models in the production of UPS for home or small servers - APC by Schneider Electric. It is from their APC Smart-UPS series that the common name of line-interactive (Smart) UPS has gone. In Russia, this line is as widely represented as in the whole world, and is constantly updated with new models of uninterruptible power supplies for servers and PCs.