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

Creating a multiboot flash drive with Ventoy

 Creating a multiboot flash drive with Ventoy




Creating a multiboot flash drive with Ventoy
To create a multiboot flash drive using the Ventoy program, you need to follow just 3 simple steps.

Step 1 - Download the Ventoy Software
As already noted, the Ventoy program has an open source code, which can be viewed on GitHub, where you can also download the distribution package of this program.

Ventoy GitHub page: https://github.com/ventoy/Ventoy/releases

After going to the page in the attachments, choose the archive for your operating system, I choose for Windows.



The note! About how I created a profile on GitHub.

Step 2 - Installing the Ventoy software on a USB flash drive
Before proceeding with the installation of the Ventoy program on a flash drive that you want to make multiboot, you must first insert this flash drive into the USB port of your computer.

Note! If there is data that is necessary and important for you on the flash drive, then you must first save it, because during the installation of the Ventoy program on the flash drive, all data on this flash drive will be deleted!

Next, unpack the previously downloaded archive, go to the Ventoy folder and run the Ventoy2Disk.exe file.



As a result, the Ventoy program will start and the main program window will be displayed. In this window, the flash drive that you inserted into the computer will already be selected. If you have several USB flash drives connected to your computer, then be sure to check whether the flash drive is selected, and if necessary, select the one you want to make multiboot.



By default, the program interface is in English, but Ventoy also supports other languages, including Russian, so to Russify the program, select the desired language in the "Language" menu.






Now, in order to install the Ventoy program on a USB flash drive, you need to click on the "Install" button, after that a window will appear, not even one, but two, which will warn you that all data from the flash drive will be deleted, in both cases, press the button "Yes".



The process will be completed when a corresponding message appears.



In the future, when new versions of the Ventoy program are released, it is not necessary to reinstall the program, just click the "Update" button.





The Ventoy program can be closed.

As a result, the flash drive will be formatted and two partitions will be created on it, the first, which is also the main one (exFAT file system), for all files (it is on this partition that you will copy all the necessary ISO files), and the second, so to speak, the system partition for booting (it allows you to boot into both BIOS and UEFI, the file system of this section is FAT).

The note! How to remove an EFI encrypted partition from a USB flash drive in Windows 10.



However, normal Windows Explorer will only show the primary partition, i.e. You may not notice the difference before and after, the only thing is that the flash drive will be empty and formatted in the exFAT file system.