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
- When creating a container, it’s necessary to open 5432 TCP port.
- Also, you should set the POSTGRES_PASSWORD environment variable with the password, to connect to PostgreSQL.
- Go to the pgAdmin downloading page – Download
- Select the desired version (in this guide we used v.4.17).
- Click on the installation file to download it.
- After the file is downloaded, run it and finish the installation process
- Start the app. By default, the interface will be opened in the new tab of your browser.
- Click on “Add New Server” on the main page.
- In the appeared pop-up window in the “Name” field enter the name of your connection.
- Go to the “Connection” tab.
- In the Host name/address field type container IP address.
- In the “Password” field you should set the POSTGRES_PASSWORD environment variable, which was specified at creating the container
- Click on “Save” to confirm the changes and establish the connection