Re: URGENT TABLE PG_SHADOW CORRUTEP

After delete all, postgres said no exist the user id 1...



The version is 7.4.8

Daniel Ricardo Medina
Ing. de Desarrollo
Computec S.A.
Tel 260 71 11 Ext 1640

-----Mensaje original-----
De: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Enviado el: Sunday, March 25, 2007 1:52 PM
Para: Daniel Ricardo Medina
CC: pgsql-admin@postgresql.org
Asunto: Re: [ADMIN] URGENT TABLE PG_SHADOW CORRUTEP

"Daniel Ricardo Medina" <dmedina@computec.com.co> writes:
> I have try to run this command in single user mod
>
> select * from pg_shadow;
> delete from pg_shadow;
> CREATE USER postgres WITH CREATEDB CREATEUSER PASSWORD '***' SYSID 1;
> CREATE USER userradar PASSWORD '***'

> but the result is the same.....

What do you see if you look in pg_shadow right after doing the DELETE?
What PG version is this?

            regards, tom lane