PostgreSQL® 16 for Red Hat® Enterprise Linux® 8 provides a secure, enterprise-ready SQL database environment built on the stable RHEL 8 platform. It supports compliant, high-performance workloads with seamless integration into Red Hat® tools, ideal for hybrid and regulated environments.
This is a quick deployment and ready-to-run image.
Simple and rapid installation. Easy to maintain.
Connecting and Configuring Database with PostgreSQL® 16 based on RHEL® 8
Before starting, go to the pgAdmin downloading page – Download, select the desired version, download, and install it.
For the connection to the server, you should know the IP address of the VM. You can find it in the personal account of Azure. Select the virtual machine from the list. By clicking the item “Overview”, your IP is displayed in the “Public IP Address” line.
For the virtual machine to function correctly, TCP port 5432 must be open in the Azure firewall. You can check this in the Network settings of your virtual machine.
Getting the password to the database
- To manage the PostgreSQL server manually, you should connect to a VM.
- With OpenSSH
In the Windows 10 operating system (starting with version 1809), an OpenSSH client is available, with which you can connect to Linux servers via SSH. If Windows 10 is suitable and the OpenSSH client is installed, you can start connecting via SSH. To do this, launch a normal Windows command prompt and enter the command “ssh user@*vm_ip*” (1), where “user” is the username that was specified while creating the virtual machine and “*vm_ip*” is the VM IP address.
Then type “Yes” (2) and enter the password (3) that was specified while creating the virtual machine.
- With the PuTTY application
Run PuTTY, enter the VM address in the “Host” field (1), and click “Open” (2) to connect.
In the opened console, you will need to enter the username (1) and password (2) that were specified while the VM was being created (you’ll not see the password in the console while entering it).
- To get the password, enter the command:
$ sudo cat /root/postgres_credentials
Save the database name, the username, and the password
- To check the server version, enter
$ psql -V
Connecting to the PostgreSQL server
- Go to the pgAdmin download page – Download, select the desired version, download, and install it
- Run pgAdmin. By default, you will be asked to set a master password
Set the password and click “OK”.
- Click “Add New Server” on the main page
- In the pop-up window, enter the name of your connection in the Name field.
- Go to the Connection tab. Enter 127.0.0.1 in the Host name/address field (1), enter the database name (2), the username (3), and the password (4) from step 2 of the previous chapter, and enable Save password (5)
- Go to the SSH Tunnel tab and click the Use SSH tunneling switch (1). In the Tunnel host field, enter the address of the virtual machine (2), in the Username field type the username to connect to VM (3), in the Password field enter the password (4), which you have used at connecting to the virtual machine. Click Save (5) to confirm the changes and establish the connection
- Your connection is ready
More information – 17: PostgreSQL 17.5 Documentation
tidalmediainc.com 