Re: pg_dump: schema with OID 145167 does not exist

"Paul Wouters" <paul.wouters@resilion.be> wrote:

> We have some problems using pg_dump. We get the following error:
>
> pg_dump: schema with OID 145167 does not exist

Make sure you have a copy of the entire PostgreSQL data directory
tree before trying to fix corruption.

> In the table pg_depend I have also e reference to 124208
>
> Can I Also remove that dependency?

You might need to delete those, after making that backup.

> We are using the 8.2.5 version of PG.

For starters you should upgrade to the last version of the
now-out-of-support 8.2 release.  After getting past the immediate
issue with the dump, you should look at upgrading to a supported
release.

www.postgresql.org/support/versioning/

-Kevin