PostgreSQL using docker

postgres-with-docker.md

PostgreSQL with docker

reference: https://davejansen.com/how-to-set-up-and-use-postgres-using-docker/

Create a new volume for each new PostgreSQL version

docker volume create pgdata96

Create a container

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

Create a DB

docker exec -i postgres96 psql -U postgres -c "CREATE DATABASE <db-name> WITH OWNER=postgres;"

Start the container

docker start postgres96

docker exec -it postgres96 psql -U postgres

Restore a dump

docker exec -i postgres96 psql -U postgres -d <dbname> -f dump.sql