Backup and Restore (pg_dump & pg_restore)

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: 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;

Please advise.

Regards,
Daulat

Responses

Browse pgsql-general by date

  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?

Browse pgsql-performance by date

  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!