Pg_restore: dropping TABLE ar_internal_metadata Pg_restore: dropping TABLE schema_migrations Pg_restore: dropping SEQUENCE webhooks_id_seq Pg_restore: dropping CONSTRAINT ar_internal_metadata ar_internal_metadata_pkey Pg_restore: dropping CONSTRAINT schema_migrations schema_migrations_pkey Pg_restore: dropping CONSTRAINT webhooks webhooks_pkey ~/Downloads/de8dc786-b133-4ae2-a040-dcf34f12c3de: file path of pg db dumpĪnd it works: pg_restore: connecting to database for restore Mohe-bc_db_1: pg container name showed by docker ps NAMES column ++ pg_restore -C -d Clarion1 /var/lib/postgresql/backup/Clarion53.backupīut if I try to restore DB from command prompt in host machine from same backup file, it is working fine.Ĭombine the most voted and Heroku's guide, I came up with this: docker exec -i mohe-bc_db_1 pg_restore -verbose -clean -no-acl -no-owner -U postgres -d mohe-bc_development < ~/Downloads/de8dc786-b133-4ae2-a040-dcf34f12c3de docker-entrypoint.sh: running /docker-entrypoint-initdb.d/initialize.sh
Pg_restore -C -d DB /var/lib/postgresql/backup/DB.backup I'm getting following error "ERROR: canceling autovacuum taskĬONTEXT: automatic analyze of table 'tablename'".ĬOPY DB.backup /var/lib/postgresql/backup/DB.backupĬOPY initialize.sh /docker-entrypoint-initdb.d/initialize.shĮcho "******PostgreSQL initialisation******" I am trying to restore database in PostgreSQL docker container using pg_restore from a shellscript that will be called from docker file.
0 kommentar(er)
