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

Re: URGENT TABLE PG_SHADOW CORRUTEP

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Daniel Ricardo Medina" <dmedina(at)computec(dot)com(dot)co>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: URGENT TABLE PG_SHADOW CORRUTEP
Date: 2007-03-25 18:51:47
Message-ID: 8911.1174848707@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
"Daniel Ricardo Medina" <dmedina(at)computec(dot)com(dot)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

In response to

Responses

pgsql-admin by date

Next:From: Peter KoczanDate: 2007-03-26 00:27:56
Subject: Re: URGENT TABLE PG_SHADOW CORRUTEP
Previous:From: Daniel Ricardo MedinaDate: 2007-03-25 02:56:56
Subject: URGENT TABLE PG_SHADOW CORRUTEP

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