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 choose the right windows - Как правильно выбрать окна

 First of all, you need to decide on the material of the profile. By type of window material, there are wooden, plastic, aluminum and metal-plastic


Also, windows can have a variety of shapes, sizes, etc. Today, every buyer can afford to choose windows for every taste.


When choosing a window, it is very important to pay attention to the double-glazed window, because this is a key detail. The number of cameras will affect the quality of heat and sound insulation of your premises.

Installation of plastic windows

The whole process of installing windows can be divided into 4 stages:


Window lock.


Dismantling the old window.


Opening preparation.


Installing a new window.


Measuring the window opening is a very important stage. It is important to consider the opening with or without a quarter (see figure below).


window installation


If the opening is without a quarter, then order a window 5 cm shorter in length than the length of the opening.


For other intricacies of installing plastic windows, read the article Installing plastic windows with your own hands.


Do-it-yourself skylights

In recent years, skylights have become increasingly popular due to the fact that people are increasingly trying to use the premises under the roof as additional living space. In this regard, the figure below shows the types of roofs that can be used to install skylights.


Roof types


The installation of roof windows has its own characteristics, unlike the installation of conventional plastic profiles. Read about the types of roof windows and the intricacies of their installation in the article Installing roof windows with your own hands.


Skylights