Getting started with postgres

Posted on 04-Jul-2018

Install database and pgadmin4 with docker compose

First you need to have docker and docker-compose installed and docker daemon running.

Then run the following commands:

# Clone setup repository
git clone https://gitlab.com/marius-rizac/docker-postgres.git

# go to repository directory
cd docker-postgres

# run containers (wait until it finishes download and setup)
docker-compose up

Once the setup is ready, you can access the admin at this url http://localhost:5050

To connect to pgadmin4 use admin@example.com and admin as password

After the connection is done, right click on Servers in top left corner below the logo and select Create > Server ...

A new window will appear and in General tab add a name, for example postgres. On the Connection tab for Host type postgres, for Username type postgres and for password type changeme. You can also select the checkbox to remember credentials.

Next, click Save.