Skip site navigation (1) Skip section navigation (2)

Re: pg_dump: schema with OID 145167 does not exist

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: <pgsql-admin(at)postgresql(dot)org>, "Paul Wouters" <paul(dot)wouters(at)resilion(dot)be>
Subject: Re: pg_dump: schema with OID 145167 does not exist
Date: 2012-03-22 15:49:18
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
"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

In response to

pgsql-admin by date

Next:From: Devrim GÜNDÜZDate: 2012-03-22 17:10:58
Subject: Re: postgresql91-devel no include [pg_config] ??
Previous:From: Kevin GrittnerDate: 2012-03-22 15:39:53
Subject: Re: german sort is wrong

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group