X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 1D75CD1B1A1 for ; Thu, 5 Aug 2004 03:12:56 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 26295-03 for ; Thu, 5 Aug 2004 06:11:52 +0000 (GMT) Received: from mail.rainbow-solutions.net (unknown [217.199.28.117]) by svr1.postgresql.org (Postfix) with ESMTP id E51D8D1B465 for ; Thu, 5 Aug 2004 03:11:10 -0300 (ADT) Received: from valeria.rainbow-solutions.net ([192.168.1.20]) by mail.rainbow-solutions.net with esmtp (Exim 3.36 #1 (Debian)) id 1BsbT0-0001Lp-00 for ; Thu, 05 Aug 2004 08:11:06 +0200 Message-ID: <4111CEBA.70109@rainbow-solutions.net> Date: Thu, 05 Aug 2004 08:07:54 +0200 From: Christian Platzer User-Agent: Mozilla Thunderbird 0.6 (Windows/20040502) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: pg_dump: schema with OID 1 does not exist X-Enigmail-Version: 0.84.1.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.1 tagged_above=0.0 required=5.0 tests=NO_DNS_FOR_FROM X-Spam-Level: * X-Archive-Number: 200408/20 X-Sequence-Number: 14415 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi there. We have a big problem with one of our databases. Postgres Server 7.3 When we try to backup the database, pg_dump exits with the following error: pg_dump: schema with OID 1 does not exist The same issue appears when we copy the entire database and try it again. All the data are stored in the public schema. Thanks a lot for helping me! Christian -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFBEc66BaT26XNCfvQRAn2uAJ4gN+tFuNaxllRmEKls3Bm0/jg8qQCfasTg Fu1QcPD4CvTj0ZAXmHR+NyU= =FtuX -----END PGP SIGNATURE-----