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
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