Fast PgAdmin via Docker

[jackblk]

Docker Compose

Create a file docker-compose.yml

version: '3.8'
services:
  pgadmin:
    container_name: pgadmin4_container
    image: dpage/pgadmin4
    restart: always
    network_mode: bridge
    volumes:
      - ./pgadmin4data:/var/lib/pgadmin
    environment:
      PGADMIN_DEFAULT_EMAIL: admin@admin.com
      PGADMIN_DEFAULT_PASSWORD: admin
    ports:
      - "5050:80"

Run & detach to background: docker compose up -d

Normal Docker container

If running normal docker container:

docker run --rm -d\
    --name pgadmin4_container \
    -e PGADMIN_DEFAULT_EMAIL=admin@admin.com \
    -e PGADMIN_DEFAULT_PASSWORD=admin \
    -v ${HOME}/sw/pgadmin/pgadmindata:/var/lib/pgadmin \
    -p 5050:80 \
    dpage/pgadmin4

PgAdmin

Open PgAdmin: http://localhost:5050

To connect to local DB running via Docker, we cannot use localhost, use the IP address from this command:

docker inspect daccel-test-postgres -f "{{json .NetworkSettings.Networks }}"

Default IP: 172.17.0.2

https://stackoverflow.com/questions/53610385/docker-postgres-and-pgadmin-4-connection-refused