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

WinSetupFromUSB


 WinSetupFromUSB is another free program for creating bootable flash drives (there is no paid version).


WinSetupFromUSB is a utility already for experienced PC users. In addition to creating a standard boot drive with an operating system image, you can use a lot of settings. For example, to make a multi-boot USB flash drive, where there will be several versions of Windows or other operating systems, this is precisely its main advantage over competitors.


Among the shortcomings, it is worth highlighting the lack of the Russian language and a narrow focus - you can only work with ISO.


SQL course for beginners


You can download it from the official site here at this link.


Brief instructions for creating a bootable USB flash drive

In the first line, select the desired drive, which will later be bootable. If the flash drive is not yet formatted, then check the box next to "Auto format it";

For media less than 4 GB, check the box next to FAT32, for flash drives from 4 GB, NTFS is suitable;

In the "Add to USB disk" section, check the box next to the OS version you are interested in and specify the path to the ISO file.

Press "GO";

Done, the creation of a bootable Windows 10 USB flash drive is completed.



If you decide to make a multiboot USB drive, then just check one more checkbox, for example, in front of Linux. You can read more about this in the material - How to create a multiboot flash drive?


In the "Options" section, you can set the parameters for a specific type of BIOS.