Re: Backup and Restore (pg_dump & pg_restore)

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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




[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux