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

Re: URGENT TABLE PG_SHADOW CORRUTEP

From: "Daniel Ricardo Medina" <dmedina(at)computec(dot)com(dot)co>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: URGENT TABLE PG_SHADOW CORRUTEP
Date: 2007-03-26 13:52:08
Message-ID: 873F3E256E0BF14EA84EAC54C2886B5D0B9835@computecnew.redcorp.computec.com (view raw or flat)
Thread:
Lists: pgsql-admin
 
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(at)sss(dot)pgh(dot)pa(dot)us] 
Enviado el: Sunday, March 25, 2007 1:52 PM
Para: Daniel Ricardo Medina
CC: pgsql-admin(at)postgresql(dot)org
Asunto: Re: [ADMIN] URGENT TABLE PG_SHADOW CORRUTEP 

"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 ElmersDate: 2007-03-26 13:55:19
Subject: Problems with precompiled pgsql on mac
Previous:From: Michael FuhrDate: 2007-03-26 13:42:53
Subject: Re: no verification of client certificate?

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