reference: https://davejansen.com/how-to-set-up-and-use-postgres-using-docker/
docker volume create pgdata96
Use a different PORT for each PostgreSQL version
version | port |
---|---|
postgres96 | 5496 |
postgres10 | 5410 |
postgres12 | 5412 |
docker run --name postgres96 -e POSTGRES_PASSWORD=123456 -d -p 5496:5432 -v pgdata96:/var/lib/postgresql/data postgres:9.6
docker exec -i postgres96 psql -U postgres -c "CREATE DATABASE <db-name> WITH OWNER=postgres;"
docker start postgres96
docker exec -it postgres96 psql -U postgres
docker exec -i postgres96 psql -U postgres -d <dbname> -f dump.sql