Backup and Restore (pg_dump & pg_restore)

Поиск
Список
Период
Сортировка
От Daulat Ram
Тема Backup and Restore (pg_dump & pg_restore)
Дата
Msg-id BL0PR01MB518710A35F4FF2A127563A2A9B200@BL0PR01MB5187.prod.exchangelabs.com
обсуждение исходный текст
Ответы Re: Backup and Restore (pg_dump & pg_restore)  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
Список 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

В списке pgsql-performance по дате отправления:

Предыдущее
От: Justin Pryzby
Дата:
Сообщение: Re: Out of Memory errors are frustrating as heck!
Следующее
От: Justin Pryzby
Дата:
Сообщение: Re: Out of Memory errors are frustrating as heck!