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 2FC209DCDD4; Thu, 12 Jan 2006 10:59:23 -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 53886-09-3; Thu, 12 Jan 2006 10:59:27 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by postgresql.org (Postfix) with ESMTP id E2B2C9DCDD0; Thu, 12 Jan 2006 10:59:20 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.13.1/8.13.1) with ESMTP id k0CExHE2022135; Thu, 12 Jan 2006 14:59:17 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.1/8.13.1/Submit) id k0CEtWQe021741; Thu, 12 Jan 2006 14:55:32 GMT (envelope-from news) From: Kai Hessing X-Newsgroups: pgsql.admin,pgsql.general Subject: Problem with restoring database from 7.3.1 to 8.0.1 Followup-To: pgsql.admin Date: Thu, 12 Jan 2006 15:55:40 +0100 Lines: 27 Message-ID: <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 To: pgsql-admin@postgresql.org.pgsql-general@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=-1.44 required=5 tests=[ALL_TRUSTED=-1.44] X-Spam-Score: -1.44 X-Spam-Level: X-Archive-Number: 200601/170 X-Sequence-Number: 20258 Hi Folks, 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; Sorry it's the german version. I think the translation could be: pg_restore: [Archivierer (DB)] Error in index directory 639; 0 33230571 CONSTRAINT $3 mh1004 pg_restore: [Archivierer (DB)] could not execute query: Error: relation »public.$3« does not exist Command was: ALTER INDEX public."$3" OWNER TO mh1004; mh1004 is the postgres user for this database. Everthing seems to work fine but I would really like to know what this error does mean. Thanks and *greets* Kai