Skip site navigation (1) Skip section navigation (2)

Re: problem

From: Zdenek Kotala <Zdenek(dot)Kotala(at)Sun(dot)COM>
To: Khobotko Oleg <oleg(at)1pr(dot)ru>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: problem
Date: 2008-04-25 10:06:09
Message-ID: 4811AD11.4040809@sun.com (view raw or flat)
Thread:
Lists: pgsql-bugs
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(at)mail(dot)ru" <spol(at)mail(dot)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
> 


In response to

  • problem at 2008-04-22 22:19:22 from Khobotko Oleg

pgsql-bugs by date

Next:From: valgogDate: 2008-04-25 16:59:54
Subject: Re: BUG #4123: Statement.setQueryTimeout does not work with Postgres Java Driver
Previous:From: Tom LaneDate: 2008-04-24 20:14:53
Subject: Re: BUG #4128: The postmaster.opts.default file is begin ignored

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group