Skip to content

[Other] Access the PostgreSQL database using a 3rd party software

Radu Raicea edited this page Sep 30, 2017 · 1 revision

If you'd like to use a 3rd part software that lets you manipulate a PostgreSQL database through a GUI, here are the instructions.

Run the application

It is very important to run the application while setting up the configuration of the connection

docker-compose up --build

Configuring the connection to the database

Every software is different, so there are no strict instructions for this. When trying to setup the connection to the database, you should use the following settings

Host: <localhost or 192.168.99.100>
Port: 2345
Username: postgres
Password: postgres

Note: The default PostgreSQL port is 5432, but by mapping the 5432 port from inside the postgres container to the host machine, it was raising errors in the application. Hence, port 2345 on the host machine maps to port 5432 inside the container.

Connecting to a database

To be able to connect to the database, your application must be running. If the application is not running, the postgres container is not up, so it is impossible to access it.