pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Zdenek Kotala <Zdenek.Kotala@Sun.COM>
To: Khobotko Oleg <oleg@1pr.ru>
Cc: pgsql-bugs@postgresql.org
Subject: Re: problem
Date: Fri, 25 Apr 2008 12:06:09 +0200
Message-ID: <4811AD11.4040809@sun.com> (raw)
In-Reply-To: <480E646A.4070508@1pr.ru>
References: <480E646A.4070508@1pr.ru>

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" <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
> 




view thread (13+ messages)  latest in thread

Message-ID: <4811AD11.4040809@sun.com>
Permalink:  ../4811AD11.4040809@sun.com/
Also on:    postgresql.org/message-id/4811AD11.4040809@sun.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-bugs@postgresql.org
  Cc: Zdenek.Kotala@Sun.COM, oleg@1pr.ru
  Subject: Re: problem
  In-Reply-To: <4811AD11.4040809@sun.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox