"Paul Wouters" <paul(dot)wouters(at)resilion(dot)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