installing postgres database and pgAdmin4 web graphic user interface in docker on debian buster

May 20th, 2021

install docker compose 

docker should already be installed and set up in your working environment. type the following code to download and install docker-compose:

sudo curl -L "https://github.com/docker/compose/releases/download/1.24.1/docker-compose-$(uname -s)-$(uname -m)" -o /usr/local/bin/docker-compose

install curl if not already

sudo apt install curl -y

mark docker-compose as executable

sudo chmod +x /usr/local/bin/docker-compose

test installation

docker-compose version

create project directory

mkdir -p ~/docker/pgdev && cd ~/docker/pgdev

create yaml config file: docker-compose.yaml

version: "3.7"

services:

  db:

    image: postgres:12.2

    restart: always

    environment:

      POSTGRES_DB: postgres

      POSTGRES_USER: admin

      POSTGRES_PASSWORD: secret

      PGDATA: /var/lib/postgresql/data

    volumes:

      - db-data:/var/lib/postgresql/data

    ports:

      - "5432:5432"

  pgadmin:

    image: dpage/pgadmin4:4.18

    restart: always

    environment:

      PGADMIN_DEFAULT_EMAIL: admin@linuxhint.com

      PGADMIN_DEFAULT_PASSWORD: secret

      PGADMIN_LISTEN_PORT: 80

    ports:

      - "8080:80"

    volumes:

      - pgadmin-data:/var/lib/pgadmin

    links:

      - "db:pgsql-server"

volumes:

  db-data:

  pgadmin-data:

start postgres and pgAdmin4

docker-compose up -d

test execution

sudo netstat -tlpn

sudo apt-get install net-tools (if not already installed)

docker-compose ps