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 <techsupp...@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* >
