Re: Backup and Restore (pg_dump & pg_restore)

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