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

From: "Techsupport" <techsupport(at)sardonyx(dot)in>
To: <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 09:29:44
Message-ID: 005101d8ab09$66e9bfc0$34bd3f40$@sardonyx.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Fabrice Chapuis 2022-08-08 16:27:46 pg_restore remap schema
Previous Message rob stone 2022-08-08 08:05:51 Re: tablesample clause doesnt support to be applied to subquery.