X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 124AC9DC819; Fri, 13 Jan 2006 11:42:01 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 28527-04; Fri, 13 Jan 2006 11:42:02 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 8A9A59DC846; Fri, 13 Jan 2006 11:41:52 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id k0DFfo3u025386; Fri, 13 Jan 2006 10:41:50 -0500 (EST) To: Kai Hessing cc: pgsql-admin@postgresql.org, pgsql-general@postgresql.org Subject: Re: [GENERAL] Problem with restoring database from 7.3.1 to 8.0.1 In-reply-to: <42n8vaF1jovc8U1@individual.net> References: <42n8vaF1jovc8U1@individual.net> Comments: In-reply-to Kai Hessing message dated "Thu, 12 Jan 2006 15:55:40 +0100" Date: Fri, 13 Jan 2006 10:41:50 -0500 Message-ID: <25385.1137166910@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.087 required=5 tests=[AWL=0.087] X-Spam-Score: 0.087 X-Spam-Level: X-Archive-Number: 200601/160 X-Sequence-Number: 20248 Kai Hessing 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