Thread: Backup and Restore (pg_dump & pg_restore)

Backup and Restore (pg_dump & pg_restore)

From
Daulat Ram
Date:

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

Re: Backup and Restore (pg_dump & pg_restore)

From
Tomas Vondra
Date:
On Sat, Apr 20, 2019 at 06:50:47PM +0000, Daulat Ram wrote:
>   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;
>
>   

How is this related to performance? Please send it to pgsql-general, and
include information about how you created the dump.

regards

-- 
Tomas Vondra                  http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services