Restore database with pg_restore

postgres_docker_restore.md

pg_restore --verbose --clean --no-acl --no-owner -n public -h db -U loldesign -d mcr_development --port 5432 ./dbdump

On Docker

docker-compose run mcr pg_restore --verbose --clean --no-acl --no-owner -n public -h db -U loldesign -d mcr_development --port 5432 ./dbdump

With text .sql bkp

cat your_dump.sql | docker exec -i your-db-container psql -U postgres

Backup database:

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