X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 0EF089DC814 for ; Wed, 18 Jan 2006 06:51:48 -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 14882-08 for ; Wed, 18 Jan 2006 06:51:48 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from floppy.pyrenet.fr (floppy.pyrenet.fr [194.116.145.2]) by postgresql.org (Postfix) with ESMTP id 099299DC984 for ; Wed, 18 Jan 2006 06:51:43 -0400 (AST) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id E32B130F0B; Wed, 18 Jan 2006 11:51:44 +0100 (MET) From: Kai Hessing X-Newsgroups: pgsql.general Subject: Re: Problem with restoring database from 7.3.1 to 8.0.1 Followup-To: pgsql.admin,pgsql.general Date: Wed, 18 Jan 2006 11:51:43 +0100 Lines: 61 Message-ID: <436ktuF1lqu87U1@individual.net> References: <42n8vaF1jovc8U1@individual.net> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-15 Content-Transfer-Encoding: 8bit User-Agent: Mozilla Thunderbird 1.0.2 (Windows/20050317) X-Accept-Language: de, en-us, en In-Reply-To: <42n8vaF1jovc8U1@individual.net> To: pgsql-general@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.16 required=5 tests=[AWL=0.160] X-Spam-Score: 0.16 X-Spam-Level: X-Archive-Number: 200601/912 X-Sequence-Number: 89857 Hi Tom, thanks for your answer. I did some testing now but still have the same problem. Tom Lane wrote: >> Kai Hessing writes: > >>>> [DB-Problem] > >> >> 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. The whole thing is a little bit strange because the indexes doesn't really seem to exist. For example the error: pg_restore: [Archivierer (DB)] Fehler in Inhaltsverzeichniseintrag 114; 0 5901799 CONSTRAINT usertypeid mh1004 pg_restore: [Archivierer (DB)] could not execute query: FEHLER: Relation »public.usertypeid« existiert nicht Command was: ALTER INDEX public.usertypeid OWNER TO mh1004; There is no index called 'public.usertypeid'. The index name is 'public.auth_usertype_pkey ' and references the row 'usertypeid' in table 'auth_usertype'. So it might be a pg_dump bug. And I do not understand the sense of this ALTER command because the whole db and everything in it belongs already to user mh1004. But the dump worked perfectly fine at our old testmachine with 7.4.x, so I'm not sure if it's really pg_dump producing the error. The pg_dump Version is the same like the database: 7.3.2. I am not able to update postgres on this server (see below). So how may I upgrade just the pg_dump? >> 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.) You're perfectly right. Just to explain: Test server: It was a fresh Suse 9.3 install and after my assistant told me that postgres is running, I tried the import. Now it's patched to 8.0.3. It is still not the newest one, but Suse doesn't seem to provide a newer precompiled version for their distribution yet. Production system: It is a 7.3.2 (my mistake) and it is hosted externally. Maybe it's something about debian and stable and so on. But it doesn't matter anymore, because I think we're switching to a new provider soon and actual patches are part of the contract.