pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Kevin Grittner <Kevin.Grittner@wicourts.gov>
To: pgsql-admin@postgresql.org
To: Paul Wouters <paul.wouters@resilion.be>
Subject: Re: pg_dump: schema with OID 145167 does not exist
Date: Thu, 22 Mar 2012 10:49:18 -0500
Message-ID: <4F6B03AE02000025000465D5@gw.wicourts.gov> (raw)
In-Reply-To: <000001cd0833$5197f580$f4c7e080$@wouters@resilion.be>
References: <000001cd0833$5197f580$f4c7e080$@wouters@resilion.be>

"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



view thread (4+ messages)  latest in thread

Message-ID: <4F6B03AE02000025000465D5@gw.wicourts.gov>
Permalink:  ../4F6B03AE02000025000465D5@gw.wicourts.gov/
Also on:    postgresql.org/message-id/4F6B03AE02000025000465D5@gw.wicourts.gov

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: Kevin.Grittner@wicourts.gov, paul.wouters@resilion.be
  Subject: Re: pg_dump: schema with OID 145167 does not exist
  In-Reply-To: <4F6B03AE02000025000465D5@gw.wicourts.gov>
  References: <000001cd0833$5197f580$f4c7e080$@wouters@resilion.be> <4F6B03AE02000025000465D5@gw.wicourts.gov>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox