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

Top video cards-Топ видеокарт

 The most popular video cards for mining are produced by NVIDIA and AMD. We present you a list of models of video cards for mining, which you should take a closer look at:


1. NVIDIA GeForce RTX 2070 SUPER. The release of this video card model was expected by most of the mining community. This model is more powerful than its predecessor, and on some cryptocurrency algorithms, the results from it are 80-160 percent higher. This card holds overclocking well, and you can also increase the frequency of the core and memory on it, and even adjust the consumption limits.


2. AMD Radeon RX 5700. These video cards are equipped with a powerful cooling system with copper pipes, fans and an aluminum radiator. It is possible to overclock the video card using the OverdriveNTool program. Best compatibility with Ethash Claymore's Miner and PhoenixMiner cryptocurrency mining software.


3. Radeon RX 580 from AMD. It is in good demand among gamers and miners from all over the world. The map is perfect for those who want to assemble a powerful farm with an optimal level of electricity consumption. The video card has good overclocking potential and processor characteristics.


4. Radeon VII Radeon. Of the benefits: high bandwidth and 16 GB memory, as well as a powerful computing core that allows you to show a high hash rate. Among the shortcomings is the high price.


5.RX 6900XT/6800XT. Having appeared on the market relatively recently, cards from AMD have made themselves known loudly. 16 GB of memory and high overclocking speed, runs on a 256-bit bus. In addition, it has a good cooling system.


6. Radeon Vega. The card has excellent throughput and, with proper overclocking on Monero, gives good timing for mining ether.


7. NVIDIA GeForce GTX 1050 Ti 1050 Ti. At the moment, this is the most affordable and common video card. With its low price, the payback of the card may not be fast, and the income from it is not very large. However, if the Ethereum rate continues to grow steadily, even taking into account the cost of electricity, it will be possible to earn some money on the video card. This video card is popular among those who assemble cryptocurrency farms, as the video card provides good performance due to special chips running on Pascal. At one time, the demand for this particular card increased sharply with the rise in prices for cryptocurrencies.


8. NVIDIA GeForce GTX 1650. A fairly productive and powerful card, but, alas, not suitable for Ethereum due to its small memory.


9. NVIDIA GeForce GTX 1080 Ti. The most expensive and most productive card in the manufacturer's lineup. The performance of this card is twice that of the GTX 1070.


Specialized cards for mining

These cards include the P104-100 and P102-100 models from NVIDIA. The cards do not have great performance and memory, but they were still popular a couple of years ago during the crypto mining hype. Moreover, these cards are not suitable for the secondary market, which means that you cannot get much profit from them by selling them.


Since today there are two manufacturers of video cards that are market leaders and compete with each other, we present to your attention the TOP cards from each


Top models of video cards from AMD:


1. RX 6900XT


2.RX6800XT


3.RX6700XT


4.RX6600XT


5.Radeon VII


6. Radeon Vega 56


7. Radeon Vega 64


8.RX 5700XT


9.RX 5600XT


10.RX 5500XT


11. RX 590


12.Radeon RX 580


13.Radeon RX 570


14.Radeon RX 470