Apr 1, 2024 1 min read

How To Deploy PGAdmin And PostgreSQL With Docker

In this tutorial, we are going to run through the steps to set up a PostgreSQL database coupled with PGAdmin with Docker.

How To Deploy PGAdmin And PostgreSQL With Docker
Table of Contents

According to the 2023 Stackoverflow Developer Survey PostgreSQL is the most loved relational and overall DBMS by developers. It has rich features that we are going to explore more in-depth with an article and discussion. Let's jump into this tutorial and set up PostgreSQL and PGAdmin with Docker:

1. Docker Compose Script And Deployment

Our initial steps are to create the docker-compose.yml file on our remote docker host where are going to deploy our containers. Copy the docker-compose script below to docker-compose.yml.

version: '3.8'
    container_name: postgresql
    image: postgres:latest
    restart: always
      - /docker/postgresql/postgresdata:/var/lib/postgresql/data
      POSTGRES_USER: root
      POSTGRES_PASSWORD: choose_password
      POSTGRES_DB: postgres-db
      - "5432:5432"
    container_name: pgadmin
    image: dpage/pgadmin4
    restart: always
      PGADMIN_DEFAULT_EMAIL: [email protected]
      PGADMIN_DEFAULT_PASSWORD: choose_password
      - "5050:80"

Once done run docker-compose up -d to deploy the two docker containers and run docker ps once deployment completes confirm that the PostgreSQL and PGAdmin containers are running.

2. Login To PGAdmin Web UI

Once confirmed that both containers are running navigate to http://<docker_host_ip>:5050 and login to the PGAdmin web UI with the PostgreSQL user created above.

PGAdmin Web UI

Once logged in you have the option to add PostgreSQL servers, and administer and maintain them. Create and delete databases and much more.


In conclusion, as mentioned above PostgreSQL is the most admired Relational and overall database management system. It is also a very good feature-rich alternative to MySQL. If you enjoyed this article consider signing up for our newsletter and don't forget to share it with people who would find it useful. Leave a comment below with a tutorial you would like us to cover.

Great! You’ve successfully signed up.
Welcome back! You've successfully signed in.
You've successfully subscribed to Opensource Geeks.
Your link has expired.
Success! Check your email for magic link to sign-in.
Success! Your billing info has been updated.
Your billing was not updated.