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: 4F6B03AE02000025000465D5@gw.wicourts.gov (view raw or flat)
Thread:
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
release.
 
www.postgresql.org/support/versioning/
 
-Kevin

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-2014 The PostgreSQL Global Development Group