Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id 2F8C42E0032 for ; Fri, 25 Apr 2008 07:08:35 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 45169-05 for ; Fri, 25 Apr 2008 07:08:10 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from gmp-eb-inf-2.sun.com (gmp-eb-inf-2.sun.com [192.18.6.24]) by developer.postgresql.org (Postfix) with ESMTP id 280DD2E003D for ; Fri, 25 Apr 2008 07:08:14 -0300 (ADT) Received: from fe-emea-09.sun.com (gmp-eb-lb-2-fe1.eu.sun.com [192.18.6.10]) by gmp-eb-inf-2.sun.com (8.13.7+Sun/8.12.9) with ESMTP id m3PA8B3P019277 for ; Fri, 25 Apr 2008 10:08:11 GMT Received: from conversion-daemon.fe-emea-09.sun.com by fe-emea-09.sun.com (Sun Java System Messaging Server 6.2-8.04 (built Feb 28 2007)) id <0JZV00A01JTA2Q00@fe-emea-09.sun.com> (original mail from Zdenek.Kotala@Sun.COM) for pgsql-bugs@postgresql.org; Fri, 25 Apr 2008 11:08:11 +0100 (BST) Received: from [192.168.2.2] ([89.103.93.253]) by fe-emea-09.sun.com (Sun Java System Messaging Server 6.2-8.04 (built Feb 28 2007)) with ESMTPSA id <0JZV001E4LH74RC0@fe-emea-09.sun.com>; Fri, 25 Apr 2008 11:08:00 +0100 (BST) Date: Fri, 25 Apr 2008 12:06:09 +0200 From: Zdenek Kotala Subject: Re: problem In-reply-to: <480E646A.4070508@1pr.ru> To: Khobotko Oleg Cc: pgsql-bugs@postgresql.org Message-id: <4811AD11.4040809@sun.com> MIME-version: 1.0 Content-type: text/plain; format=flowed; charset=UTF-8 Content-transfer-encoding: 8BIT References: <480E646A.4070508@1pr.ru> User-Agent: Thunderbird 2.0.0.6 (X11/20071119) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200804/204 X-Sequence-Number: 20416 The first record ctid=(0,1) is obsolete, you can delete it. It is probably race condition in VACUUM and catalog modification. Did you added or modified any user account (e.g. password change) in related time? Please, can you let us know exact version of PostgreSQL? Zdenek Khobotko Oleg napsal(a): > Hello, help me please, > I don't know how, but i got 2 postgres users. > How can I delete the first one ???? > thx alot for your answers. > /////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// > > select passwd,ctid,xmin,xmax,cmin,cmax from pg_shadow where usesysid =1; > passwd | ctid | xmin | xmax | cmin > | cmax > -------------------------------------+-------+------+----------+----------+----- > - > | (0,1) | 1 | 16754522 | 16754522 > | 0 > md510db8c04d26d32185270721fcf32155 | (0,2) | 2 | 0 | 0 > | 0 > (2 rows) > ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// > > select * from pg_shadow where usesysid=1; > usename | usesysid | usecreatedb | usesuper | usecatupd | > passwd > | valuntil | useconfig > ----------+----------+-------------+----------+-----------+--------------------- > ----------------+----------+----------- > postgres | 1 | t | t | t > | > | | > postgres | 1 | t | t | t | > md510db8c04d231142d5 > 270721fcf740ed5 | infinity | > (2 rows) > //////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// > > > Tom Lane пишет: > "spol@mail.ru" writes: > >> I have two "postgres" user. How to delete the first one ??? >> > > Let's see the system columns (ctid,xmin,xmax,cmin,cmax) for those > two rows? > > regards, tom lane >