Guide – How To Start – PostgreSQL 12.2 Container on Linux Alpine 3.12

PostgreSQL is an object-relational database system(ORDBMS). ACID-compliant, it supports foreign keys, joins, views, triggers, and stored procedures and well-known for reliability and data integrity.

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

The connection to PostgreSQL using pgAdmin 4

How to create and configure the Azure Container Registry and to start creating the Container, you can find Here

1. When creating a container, it’s necessary to open 5432 TCP port.

2. Also, you should set the POSTGRES_PASSWORD environment variable with the password, to connect to PostgreSQL.

3. Go to the pgAdmin downloading page – Download
4. Select the desired version (in this guide we used v.4.17).
5. Click on the installation file to download it.

6. After the file is downloaded, run it and finish the installation process 
7. Start the app. By default, the interface will be opened in the new tab of your browser.
8. Click on “Add New Server” on the main page.

9. In the appeared pop-up window in the “Name” field enter the name of your connection.

10. Go to the “Connection” tab.
11. In the Host name/address field type container IP address.

12. In the “Password” field you should set the POSTGRES_PASSWORD environment variable, which was specified at creating the container
13. Click on “Save” to confirm the changes and establish the connection