requirements:

• docker installed
• docker-compose installed

setup

steps

1. git clone https://github.com/jforge/compose-postgres.git
2. cd compose-postgres
3. docker-compose up

result

• postgres running on 5432
  • user: postgres
  • password: changeme
• pgadmin4 running on 5050
  • user: pgadmin4@pgadmin.org
  • password: admin

configuration

local connection

Use hostname postgres for a local connection configured in pgadmin4

postgres data

By default this composition expects path ~/data/postgres to be mapped to /data/postgres (container).

In order to change this on a MacOS properly, follow the Docker for Mac :: File system sharing (osxfs) docs.

tools

restore

use the restore_db.sh script with a dump as an argument to restore a database into the dockerized postgresql server.