"Paul Wouters" <paul.wouters@xxxxxxxxxxx> 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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
