Toy postgres instance with `pgadmin4` and docker compose

ABOUT.md

Getting a postgres instance with pgadmin4 🐘 and docker-compose 🐳

0. Use Linux and have docker and docker-compose installed.
1. Create a folder
2. Put docker-compose.yml and servers.json

• Optional: Put a SQL script to be executed at first run from the db service.

3. docker-compose up -d
4. Go to 0.0.0.0:5050 and login with test@test.com and test as password
5. Access the database with the test password
6. You have a database to play!

To get rid of these containers, use docker-compose down. Pass -v to get rid of any persisted data. In case of doubts, check the docker documentation.

docker-compose.yml

version: "3.7"

services:
  db:
    # https://hub.docker.com/_/postgres/
    image: "postgres:10"
    restart: always
    environment:
      - POSTGRES_PASSWORD=test
    volumes:
      - pgdata:/var/lib/postgresql/data
    ports:
      - 5555:5432
    networks:
      db_nw:
        aliases:
          - postgres

  pgadmin:
    image: dpage/pgadmin4:4
    restart: always
    environment:
      - PGADMIN_DEFAULT_EMAIL=test@test.com
      - PGADMIN_DEFAULT_PASSWORD=test
    volumes:
      - ./servers.json:/pgadmin4/servers.json
    ports:
      - 5050:80
    depends_on:
      - db
    networks:
      db_nw:
        aliases:
          - pgadmin

networks:
  db_nw:
    driver: bridge

volumes:
  pgdata:

servers.json

{
  "Servers": {
    "1": {
      "Name": "DemoDB",
      "Port": 5432,
      "Username": "postgres",
      "Group": "DEMO",
      "Host": "postgres",
      "SSLMode": "prefer",
      "MaintenanceDB": "postgres",
      "Comment": "This server was configured using a JSON. See <https://www.pgadmin.org/docs/pgadmin4/3.6/export_import_servers.html?highlight=servers%20json>"
    }
  }
}