Thread: problem

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

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
>