Backup and Restore (pg_dump & pg_restore)

[Daulat Ram <Daulat.Ram@xxxxxxxxxxxxxxx>]

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