Re: Pg_restore failing due to data inconsistency in dump file

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Pg_restore failing due to data inconsistency in dump file
Дата
Msg-id CAKFQuwY8n=cM3BxKSVX73MLuWDAHeB7gwpwQOjwQHHU4W4vA_A@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Pg_restore failing due to data inconsistency in dump file  (soumitra bhandary <soumitra.bhandary@hotmail.com>)
Список pgsql-admin
Дерево обсуждения
On Thu, Dec 13, 2018 at 7:26 AM soumitra bhandary <soumitra.bhandary@hotmail.com> wrote:
But this one is third party application and dump is restored from dump file not plain text file . So is there any way to control it ?

Your backup file (and the source database is comes from) is corrupted.

You need to decide whether you want to restore that backup anyway; or just throw it away, fix the source database, and generate a new backup file.

If you want to do the former you will want to restore schema only.  Modify the schema by dropping the foreign key.  Restore the data.  Fix the newly restored data.  Recreate the foreign key.

David J.

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

Предыдущее
От: soumitra bhandary
Дата:
Сообщение: Re: Pg_restore failing due to data inconsistency in dump file
Следующее
От: Artem Tomyuk
Дата:
Сообщение: pg_attribute getting bloated in size