From: | Daulat Ram <Daulat(dot)Ram(at)exponential(dot)com> |
---|---|
To: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Backup and Restore (pg_dump & pg_restore) |
Date: | 2019-04-21 16:35:59 |
Message-ID: | BL0PR01MB51872B41EDB099721B5606E59B210@BL0PR01MB5187.prod.exchangelabs.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-performance |
Hello Team,
We are getting below error while migrating pg_dump from Postgresql 9.6 to Postgresql 11.2 via pg_restore in docker environment.
90d4c9f363c8:~$ pg_restore -d kbcn "/var/lib/kbcn_backup19"
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 3; 2615 2200 SCHEMA public postgres
pg_restore: [archiver (db)] could not execute query: ERROR: schema "public" already exists
Command was: CREATE SCHEMA public;
Script used for pg_dump:
-------------------------------------
pg_dump -h 10.26.33.3 -p 5432 -U postgres -W -F c -v -f tmp/postgres/backup/backup10/ kbcn_backup19 kbcn >& tmp/postgres/backup/backup10/ kbcn_backup19.log; echo $? > tmp/postgres/backup/backup10/_'date+%Y-%m-%d.%H:%M:%S'
Please advise.
Regards,
Daulat
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2019-04-21 18:46:09 | Re: Backup and Restore (pg_dump & pg_restore) |
Previous Message | Tomas Vondra | 2019-04-21 16:18:24 | Re: Backup and Restore (pg_dump & pg_restore) |
From | Date | Subject | |
---|---|---|---|
Next Message | Justin Pryzby | 2019-04-21 16:40:22 | Re: Out of Memory errors are frustrating as heck! |
Previous Message | Tomas Vondra | 2019-04-21 16:18:24 | Re: Backup and Restore (pg_dump & pg_restore) |