From: | Rodriguez Fernando <rodriguez(at)ort(dot)edu(dot)uy> |
---|---|
To: | "spol(at)mail(dot)ru" <spol(at)mail(dot)ru> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: help me plz with 2 postgres users |
Date: | 2008-02-27 11:15:51 |
Message-ID: | 47C54667.1070902@ort.edu.uy |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
spol(at)mail(dot)ru wrote:
> Hello?
> help me plz? i don't khow what to do...
>
> How can I delete first postgres user.
>
> template1=# select usename,passwd,valuntil,ctid,xmin,xmax,cmin,cmax
> from pg_shadow where usesysid=1;
> usename | passwd | valuntil | ctid |
> xmin | xmax | cmin | cmax
> ----------+-------------------------------------+----------+-------+------+----------+----------+------
>
> postgres | | | (0,1) |
> 1 | 16754522 | 16754522 | 0
> postgres | md65476547442532.. | infinity | (0,2) | 2 |
> 0 | 0 | 0
> (2 rows)
>
> thx for your help.
> Oleg
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>
Hola, no se me ocurre como ayudarte pero podrias hace asi la consulta:
select usename||'-',passwd,valuntil,ctid,xmin,xmax,cmin,cmax from
pg_shadow where usesysid=1;
Que version de postgres estas usando?
From | Date | Subject | |
---|---|---|---|
Next Message | Zubkovsky, Sergey | 2008-02-27 12:31:10 | Internal Error on 'vacuum full' |
Previous Message | Pieter Jansen | 2008-02-27 09:56:30 | Re: panic? return of the btree-bug |