Backup/restore postgres in docker container

Backup, restore postgres in docker container

Backup:
docker exec -t -u postgres your-db-container pg_dumpall -c > dump_`date +%d-%m-%Y"_"%H_%M_%S`.sql

Restore:
cat your_dump.sql | docker exec -i your-db-container psql -Upostgres

As explained in this article: http://durandom.de/docker/postgres/2016/12/20/pg_dump/ you should not pass -t to docker exec to backup your DB.

Missing whitespace in restore command between "-U" and "postgres"

To restore your dump file with specified user and database_name

cat your_dump.sql | docker exec -i {docker-postgres-container} psql -U {user} -d {database_name}

I am getting a lot of these when I try to restore:
ERROR: constraint "something" for relation "something" already exists

Ao fazer isso:
cat your_dump.sql | docker exec -i {docker-postgres-container} psql -U {user} -d {database_name}

Obtive o seguinte erro:
Got permission denied while trying to connect to the Docker daemon socket at unix:///var/run/docker.sock: Post http://%2Fvar%2Frun%2Fdocker.sock/v1.26/containers/banco/exec: dial unix /var/run/docker.sock: connect: permission denied

@romulo-soares You need to use sudo before docker if you are not root (tens de usar sudo se não estás logado com root):

cat your_dump.sql | sudo docker exec -i {docker-postgres-container} psql -U {user} -d {database_name}

@romulo-soares You need to use sudo before docker if you are not root (tens de usar sudo se não estás logado com root):

cat your_dump.sql | sudo docker exec -i {docker-postgres-container} psql -U {user} -d {database_name}

Hello, you can use the user that has permissions to run docker commands and not root.
It is recommended to run docker as a different user then root.

if you provided a label (i.e. foo=bar) you can also use the following (useful for autobackup in a cron script):
docker exec $(docker ps --filter label=foo=bar | awk '{print $11}') pg_dumpall -c -U postgres > test_dump_`date +%d-%m-%Y"_"%H_%M_%S`.sql