| From: | Daulat Ram <Daulat(dot)Ram(at)exponential(dot)com> |
|---|---|
| To: | "pgsql-performance(at)lists(dot)postgresql(dot)org" <pgsql-performance(at)lists(dot)postgresql(dot)org> |
| Subject: | Backup and Restore (pg_dump & pg_restore) |
| Date: | 2019-04-20 18:50:47 |
| Message-ID: | BL0PR01MB518710A35F4FF2A127563A2A9B200@BL0PR01MB5187.prod.exchangelabs.com |
| Views: | Whole Thread | Raw Message | 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;
Please advise.
Regards,
Daulat
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pavan Kumar | 2019-04-20 21:34:17 | postgres database complete recovery |
| Previous Message | Morris de Oryx | 2019-04-20 12:27:35 | Re: Where to store Blobs? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Justin Pryzby | 2019-04-20 19:30:09 | Re: Out of Memory errors are frustrating as heck! |
| Previous Message | Justin Pryzby | 2019-04-20 10:53:36 | Re: Out of Memory errors are frustrating as heck! |