Re: 20220722-pg_dump: error: invalid number of parents 0 for table

Поиск
Список
Период
Сортировка
От Saul Perdomo
Тема Re: 20220722-pg_dump: error: invalid number of parents 0 for table
Дата
Msg-id CAN3jBgH7ajsPYCZCvi11vxWxWBjCRmHADXCaBP-ZCrj=tnUDxw@mail.gmail.com
обсуждение исходный текст
Ответ на RE: 20220722-pg_dump: error: invalid number of parents 0 for table  ("Techsupport" <techsupport@sardonyx.in>)
Список pgsql-general
hey Karthick, if you've made triple sure that it's not a permissions issue, take a look at some of the suggestions in this old thread: https://dba.stackexchange.com/questions/17546/why-is-pg-dumpall-throwing-an-oid-does-not-exist-error

On Mon, Aug 8, 2022 at 5:30 AM Techsupport <techsupport@sardonyx.in> wrote:

Hi to all,

 

We are using PostgreSQL 12.3 and it is running under Windows environment. In my server multiple databases are available.

 

When we try to Back up one of the database, it gives the following error message, we can able to connect and read & write to the database.

But unable to back up the database , We faced this issue on one database only, remaining databases are working good and able to backup. Suggest me, How to resolve this issue.

 

pg_dump: last built-in OID is 16383

pg_dump: reading extensions

pg_dump: identifying extension members

pg_dump: reading schemas

pg_dump: reading user-defined tables

pg_dump: reading user-defined functions

pg_dump: reading user-defined types

pg_dump: error: schema with OID 1020797 does not exist

 

Thanks,

Karthick Ramu

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

Предыдущее
От: Marcos Pegoraro
Дата:
Сообщение: Re: pg_restore remap schema
Следующее
От: Fabrice Chapuis
Дата:
Сообщение: Re: pg_restore remap schema