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 879D3D6D83 for ; Thu, 1 Sep 2005 14:17:40 -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 72606-03 for ; Thu, 1 Sep 2005 17:17:36 +0000 (GMT) Received: from mail133.pi.net.pl (gips.pi.net.pl [195.116.221.99]) by svr1.postgresql.org (Postfix) with SMTP id 56088D84CE for ; Thu, 1 Sep 2005 14:17:33 -0300 (ADT) Received: (qmail 11948 invoked from network); 1 Sep 2005 17:17:31 -0000 Received: from unknown (HELO ?81.168.138.82?) (grubby@81.168.138.82) by 195.205.153.133 with SMTP; 1 Sep 2005 17:17:30 -0000 Message-ID: <431737A7.8030602@epf.pl> Date: Thu, 01 Sep 2005 19:17:27 +0200 From: GRUbY User-Agent: Mozilla Thunderbird 1.0.6 (X11/20050727) X-Accept-Language: en MIME-Version: 1.0 To: Tom Lane Cc: pgsql-admin@postgresql.org Subject: Re: pg_dumpall problem - duplicated users References: <20050901134207.7274CD88A0@svr1.postgresql.org> <12902.1125587084@sss.pgh.pa.us> In-Reply-To: <12902.1125587084@sss.pgh.pa.us> Content-Type: text/plain; charset=ISO-8859-2; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.024 required=5 tests=[RCVD_BY_IP=0.024] X-Spam-Level: X-Archive-Number: 200509/6 X-Sequence-Number: 18743 Tom Lane napisał(a): >"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 > > I'm using exactly PostgreSQL 7.3.9 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.4.2 20041017 (Red Hat 3.4.2-6.fc3) :] If it helps: postgres=> select ctid,xmin,xmax,cmin,xmax,* from pg_shadow where usename = 'postgres'; ctid | xmin | xmax | cmin | xmax | usename | usesysid | usecreatedb | usesuper | usecatupd | passwd | valuntil | useconfig --------+------------+-------+-------+-------+----------+----------+-------------+----------+-----------+-------------------------------------+----------+----------- (0,1) | 1 | 50469 | 50469 | 50469 | postgres | 1 | t | t | t | | | (1,25) | 2559800612 | 0 | 0 | 0 | postgres | 1 | t | t | t | md5c084502ed11efa9d3d96d29717a5e555 | | (2 rows) If U have any ideas or more questions please write. Like I said, my deadline is near :[ Now i'm thinking about writing a script to backup all data and schemas from all dbs by myself and reinstallin PG... but it is a lot of work and i cant check if i did everything right for sure :( Greetings, Bartek