Thread: help me please
hello
Help me please...
I have two "postgres" user. How to delete the first one ???
*******************
# 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 |
md53532747417351142d5270721fcf740ed5 | infinity |
(2 rows)
*******************
*******************
# select * from pg_user where usesysid=1;
usename | usesysid | usecreatedb | usesuper | usecatupd | passwd |
valuntil | useconfig
----------+----------+-------------+----------+-----------+----------+----------+-----------
postgres | 1 | t | t | t | ********
| |
postgres | 1 | t | t | t | ******** |
infinity |
(2 rows)
*******************
I tried
delete from pg_shadow where passwd is null;
but it's not working.
Help me please
oleg
On Dec 28, 2007 7:01 AM, spol@mail.ru <spol@mail.ru> wrote: > hello > > Help me please... > I have two "postgres" user. How to delete the first one ??? > > ******************* > # 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 | > md53532747417351142d5270721fcf740ed5 | infinity | > (2 rows) > ******************* > > ******************* > # select * from pg_user where usesysid=1; > usename | usesysid | usecreatedb | usesuper | usecatupd | passwd | > valuntil | useconfig > ----------+----------+-------------+----------+-----------+----------+----------+----------- > postgres | 1 | t | t | t | ******** > | | > postgres | 1 | t | t | t | ******** | > infinity | > (2 rows) > ******************* > > > I tried > delete from pg_shadow where passwd is null; > > but it's not working. > > Help me please > oleg pg_shadow is a view based on pg_authid. Try deleting it from pg_authid. Note that pg_authid is defined with OIDs, which might also be useful for you. - Josh / eggyknap
"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
"Josh Tolley" <eggyknap@gmail.com> writes:
> pg_shadow is a view based on pg_authid.
Not in 7.4 it wasn't ...
regards, tom lane
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
>
>
>