Knowledgebase/Docker/Postgres Docker.md

In this note is described how to work with dumps from a psql docker container

Creating a dump

docker exec -i <container_name> /bin/bash -c "PGPASSWORD=<password> pg_dump --clean --username <username> postgres" > ./<targetname>.sql

Restore dump to container

docker exec -i <container_name> /bin/bash -c "PGPASSWORD=<password> psql --username <username> postgres" < ./<targetname>.sql