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

What is CMS


 What is CMS


In today's world, only a small part of sites are created from scratch, i.e. through full-fledged programming, development of functionality, interface and the entire logic of the site, usually this is how large information systems or some specialized services are developed.


Most websites today are built using so-called "content management systems (CMS)", commonly referred to as the "website engine". But what is it?


CMS is an application (a set of scripts) that can be installed on hosting and created with the help of it your own full-fledged personal website and its further maintenance, i.e. fill and edit the content of the site (its content).


At the same time, you will not be programming in the classical sense, i.e. You do not need to know programming languages, you will not write code, you will create a website by installing the necessary extensions (plugins), configuring these extensions, configuring the CMS itself, this whole process reminds me of the process of setting up the operating system (Windows or Linux) for yourself, those. If we draw an analogy, then the operating system acts as a CMS, and the programs that you install into the system act as extensions (plugins).

In other words, websites today are created in exactly the same way as you set up an operating system, install programs into it, and set up these programs without programming at all.


Thus, in the modern world, creating a website is actually quite simple, you just need to know the basic principles of working with CMS.


The whole problem is that there are a lot of such CMS, some are aimed at creating blogs, some are aimed at creating online stores, some are paid, and some are free, the same can be said about extensions, there are extensions paid, and there are also free.


Therefore, in order to create a website, a person needs to select a CMS, configure it, select the necessary extensions, and configure them, as well as check the correctness of their work.