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*
>
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 |