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

Disadvantages of PoS

Disadvantages of PoS


On the market, you can find a fairly large number of cryptocurrencies that work on a hybrid algorithm. Pure Proof-of-Stake is relatively rare, as there are several drawbacks.

One of the main ones is the unfair distribution of coins. The volume of the reward for an open block is determined by whoever has the most of a particular variety of cryptocurrency. This does not allow for complete decentralization. It is most profitable to own cryptocurrency in large volume, which leads to a monopoly of the market. Developers distribute the entire amount of money even before the moment when they enter the market. Early investors find themselves in the most favorable conditions, which does not attract new users. Large investors determine almost all development prospects.

There is a threat of an attack that will be provoked by the largest owners of coins. If the cryptocurrency is sold cheaply, then the coins can be bought in large quantities for a relatively small amount and gain control over most of the entire assets of the system. This allows attackers to resort to various manipulations.

Probability of parallel transactions. There may be two users in the system, the parameters of which will be the same. If the blocks are signed at the same time, both will be correct. Despite the existing shortcomings, the system still has prospects, as the creators are upgrading and working on bugs.