Guide – How To Start – PostgreSQL15 on Oracle 9 on Amazon

PostgreSQL 15 on Oracle 9 offers a stable, secure, and performant SQL platform built for mission-critical systems running on the latest Oracle Linux version.

This is a quick deployment and ready-to-run image.
Simple and rapid installation. Easy to maintain.

Connecting and configuring PostgreSQL15 on Oracle 9 using pgAdmin 4 through SSH Tunnel

When starting the VM, the server starts automatically.

Getting the password to the database

1. To manage the PostgreSQL server manually, you should connect to a VM. 

• To get the password, you should connect to the VM. To do that, generate a “Private Key” in advance. This can be done using the following instructions Guide – How To – Create and use Key Pair to connect to a VM. You need to use the .pem file from step 4 of the guide.

• Download and run Putty

• Go to the “SSH” section in the left panel (1) and then to “Auth” (2).

In the “Auth” section, click “Browse” and specify the path to the .ppk file you received earlier.

• Go to the home page of “Session”, enter the IP address of the VM (1), and click “Open” (2).

• In the opened console, you will need to enter the login ec2-user

2. To get the password, enter the command sudo cat /root/postgres_credentials

Save the password

3. To check the server version enter

$ psql -V

Connecting to the Postgresql server

1. Go to the pgAdmin download page – Download, select the desired version, download, and install it

2. Run pgAdmin. By default, you will be asked to set a master password

Set the password and click “OK”.

3. Click “Add New Server” on the main page

4. In the pop-up window, enter the name of your connection in the Name field.

5. Go to the Connection tab. Enter “127.0.0.1” in the Host name/address field (1), enter the password from step 2 of the previous chapter in the Password field (2), and enable Save password (3)

6. 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 ubuntu (3), select Identity file (4) and enter the path to your .pem file in the Identity file field (5). Click “Save” (6) to confirm the changes and establish the connection

7. Your connection is ready

More information – PostgreSQL 15 Documentation