X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 15E04D705B for ; Thu, 25 Aug 2005 05:52:15 -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 89566-07 for ; Thu, 25 Aug 2005 08:52:12 +0000 (GMT) Received: from tales.tey.pl (tales.tey.pl [217.153.66.195]) by svr1.postgresql.org (Postfix) with ESMTP id DBB01D703A for ; Thu, 25 Aug 2005 05:52:11 -0300 (ADT) Received: from [192.168.1.1] (unknown [217.153.66.193]) by tales.tey.pl (Postfix) with ESMTP id CD0E3174008 for ; Thu, 25 Aug 2005 10:52:11 +0200 (CEST) Message-ID: <430D86BB.90806@tey.pl> Date: Thu, 25 Aug 2005 10:52:11 +0200 From: =?ISO-8859-2?Q?Przemys=B3aw_Nogaj?= User-Agent: Mozilla Thunderbird 1.0.2-6 (X11/20050513) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: pg_dumpall problem - duplicated users Content-Type: text/plain; charset=ISO-8859-2; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 required=5 tests=[none] X-Spam-Level: X-Archive-Number: 200508/340 X-Sequence-Number: 18659 Hi, few days ago we made vacuum of all databases on our server. After that we canot dump databases: # pg_dumpall -i -U postgres > test.sql pg_dump: query to obtain list of schemas failed: ERROR: More than one tuple returned by a subselect used as an expression. pg_dumpall: pg_dump failed on database "alibi", exiting There are duplicated system users, pg_catalogs, pg_temp1, pg_toast and public... template1=> select * from pg_catalog.pg_shadow where usesysid = 1; usename | usesysid | usecreatedb | usesuper | usecatupd | passwd | valuntil | useconfig ----------+----------+-------------+----------+-----------+-------------------------------------+----------+----------- postgres | 1 | t | t | t | | | postgres | 1 | t | t | t | md5c084502ed11efa9d3d96d29717a5e555 | | (2 rows) Any suggestions how to solve the problem? There are many databases on the server we can't loose. Applications can connect to databases - all works fine, hoewer we must make dumps... Thanks for any help, Greetings Przemek