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

From: Saul Perdomo <saul(dot)perdomo(at)gmail(dot)com>
To: Techsupport <techsupport(at)sardonyx(dot)in>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: 20220722-pg_dump: error: invalid number of parents 0 for table
Date: 2022-08-08 23:55:23
Message-ID: CAN3jBgH7ajsPYCZCvi11vxWxWBjCRmHADXCaBP-ZCrj=tnUDxw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)sardonyx(dot)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*
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Fabrice Chapuis 2022-08-09 06:39:17 Re: pg_restore remap schema
Previous Message Zheng Li 2022-08-08 20:22:33 Re: Support logical replication of DDLs