1. delete all existing tables: docker exec -i foo_container /bin/bash -c "export PGPASSWORD=barbar && /usr/bin/psql -U foo foodb -c 'DROP SCHEMA public CASCADE; CREATE SCHEMA public'" 2. restore the postgres db from a file: gunzip < init/foodb.sql.gz | docker exec -i foo_container /bin/bash -c "export PGPASSWORD=barbar && /usr/bin/psql -U foo foodb"

https://devopsheaven.com/postgresql/psql/databases/docker/backup/restore/2017/09/10/restore-postgresql-database-using-docker.html

maybe you need permission: 1. su - postgres 2. psql 3. ALTER ROLE dcms WITH SUPERUSER CREATEDB CREATEROLE REPLICATION; 3. check: \du should be like: Role name | Attributes | Member of -----------+------------------------------------------------------------+----------- dcms | Superuser, Create role, Create DB, Replication | {} postgres | Superuser, Create role, Create DB, Replication, Bypass RLS | {} 26.11.19

• Home
• Notebook
• Contact us

• Privacy Statement
• 

Copyleft ☠ 2025