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 20F5BD8466 for ; Thu, 1 Sep 2005 12:04:50 -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 41677-01 for ; Thu, 1 Sep 2005 15:04:48 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 1B254D8462 for ; Thu, 1 Sep 2005 12:04:47 -0300 (ADT) 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 j81F4icT012903; Thu, 1 Sep 2005 11:04:45 -0400 (EDT) To: "Bartek GRUbY" Cc: pgsql-admin@postgresql.org Subject: Re: pg_dumpall problem - duplicated users In-reply-to: <20050901134207.7274CD88A0@svr1.postgresql.org> References: <20050901134207.7274CD88A0@svr1.postgresql.org> Comments: In-reply-to "Bartek GRUbY" message dated "01 Sep 2005 15:42:10 +0200" Date: Thu, 01 Sep 2005 11:04:44 -0400 Message-ID: <12902.1125587084@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 required=5 tests=[AWL=0.006] X-Spam-Level: X-Archive-Number: 200509/4 X-Sequence-Number: 18741 "Bartek GRUbY" writes: > i have similar problem - can't make dumps of any db with the same error message (and all applications using this pg server works fine) . But in my case, i think, only user 'postgres' is duplicated: > template1=> select * from pg_catalog.pg_shadow where usename = 'postgres'; > usename | usesysid | usecreatedb | usesuper | usecatupd | passwd | valuntil | useconfig > ----------+----------+-------------+----------+-----------+-------------------------------------+----------+----------- > postgres | 1 | t | t | t | | | > postgres | 1 | t | t | t | md5c084502ed11efa9d3d96d29717a5e555 | | > (2 rows) What PG version are you using exactly? Could we see the system columns for those rows, ie, select ctid,xmin,xmax,cmin,xmax,* from pg_shadow where usename = 'postgres'; regards, tom lane