From: Tom Lane <tgl@sss.pgh.pa.us>
To: Kai Hessing <kai.hessing@hobsons.de>
Cc: pgsql-admin@postgresql.org
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Problem with restoring database from 7.3.1 to 8.0.1
Date: Fri, 13 Jan 2006 10:41:50 -0500
Message-ID: <25385.1137166910@sss.pgh.pa.us> (raw)
In-Reply-To: <42n8vaF1jovc8U1@individual.net>
References: <42n8vaF1jovc8U1@individual.net>
Kai Hessing <kai.hessing@hobsons.de> writes:
> I have a small problem. We're currently using an old PostgreSQL 7.3.1
> database. In near future we want to migrate to a new server and taking
> the chance to upgrade postgres. Now I have a testsystem with postgres
> 8.0.1 where I tried to import a dump from our database. Everthing works
> fine except 74 error messages which all look simliar to this one:
> pg_restore: [Archivierer (DB)] Fehler in Inhaltsverzeichniseintrag 639;
> 0 33230571 CONSTRAINT $3 mh1004
> pg_restore: [Archivierer (DB)] could not execute query: FEHLER:
> Relation »public.$3« existiert nicht
> Command was: ALTER INDEX public."$3" OWNER TO mh1004;
Hmm. This looks like a pg_dump bug, ie, issuing ALTER OWNER commands
for the wrong index name (or, perhaps, issuing them before having
created the index ... do you use any indexes named like that?).
Which pg_dump version did you use to make the dump? The usual
recommendation is to use the newer version's pg_dump in this sort
of situation.
BTW, you should *not* be updating to 8.0.1. 8.0.6 is the latest release
in that series. It is almost never a good idea to be running anything
but the latest minor release in a series. (The fact that you're still
on 7.3.1 doesn't speak well for your attentiveness to updates either.
We don't make minor releases just to keep busy, you know.)
regards, tom lane
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: tgl@sss.pgh.pa.us, kai.hessing@hobsons.de, pgsql-general@postgresql.org
Subject: Re: [GENERAL] Problem with restoring database from 7.3.1 to 8.0.1
In-Reply-To: <25385.1137166910@sss.pgh.pa.us>
References: <42n8vaF1jovc8U1@individual.net> <25385.1137166910@sss.pgh.pa.us>
* 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