How to run PostgreSQL on Docker

Make sure you have already installed Docker.

By running below command, you can see docker images you have on your local computer.

You’re going to need postgres and dpage/pgadmin4 images for PostgreSQL local set up but before pulling these images if you ever want to remove an image, run below command.

Then pull the required images.

To see if you successfully pulled these images, you can run

command again.

By running below command, you can see docker containers you have on your computer.

Before creating containers from postgres and dpage/pgadmin4 images, if you ever want to remove a container, run below command.

Run below command to create postgres container.

— name : postgres container name on your local

POSTGRES_USER : postgresql db user name

POSTGRES_PASSWORD : postgresql db password

POSTGRES_DB : postgresql db name

Run below command to create dpage/pgadmin4 container.

PGADMIN_DEFAULT_EMAIL : pgAdmin page login email

PGADMIN_DEFAULT_PASSWORD : pgAdmin page login password

— name : dpage/pgadmin4 container name on your local

To see if these containers running successfully, you can run

command again.

Last but not least, we need to look at IP address of the PostgreSQL container. We will use that IP address while defining connection in pgAdmin. Run below command and copy the IP address parameter.
( something like “IPAddress”:”172.17.0.2" )

Then connect to below address to login pgAdmin.

http://localhost:80

Add new server with these parameters.

Host name/address : IP address that you copied above

Port = 5432

Maintenance database : POSTGRES_DB name, we assigned it above as dockerdb

Username : POSTGRES_USER username, we assigned it above as dockeruser

Password : POSTGRES_PASSWORD password, we assigned it above as dockerpass

Now, you can start to use PostgreSQL database on Docker.

Connect Docker PostgreSQL with IntelliJ IDEA
Springboot application.properties for Docker PostgreSQL

Software Engineer