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

Re: no verification of client certificate?

From: "Daniel Ricardo Medina" <dmedina(at)computec(dot)com(dot)co>
To: <pgsql-admin(at)postgresql(dot)org>
Cc: <pgsql-es-ayuda-owner(at)postgresql(dot)org>
Subject: Re: no verification of client certificate?
Date: 2007-03-23 23:19:03
Message-ID: 873F3E256E0BF14EA84EAC54C2886B5D0B982E@computecnew.redcorp.computec.com (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-docs
Ayuda por favor

Cuando ejecuto este comando me sale una doble tupla del usuario
postgres, esto me error cuando ejecuto el comando
Pg_dump para realizar el respectivo backup..


radar=# select * from pg_user;
  usename  | usesysid | usecreatedb | usesuper | usecatupd |  passwd  |
valuntil | useconfig
-----------+----------+-------------+----------+-----------+----------+-
---------+-----------
 postgres  |        1 | t           | t        | t         | ******** |
|
 postgres  |        1 | t           | t        | t         | ******** |
|
 userradar |      100 | f           | f        | f         | ******** |
|
(3 rows)

He intentado borrar los usuario directamente de la tabla subiendo
postgres com postgres -O -P  -D directorio

Y corriendo estos comandos..

select * from pg_shadow;
delete from pg_shadow;
CREATE USER postgres WITH CREATEDB CREATEUSER PASSWORD '***' SYSID 1;
CREATE USER  userradar  PASSWORD '***' 

Pero me crea los mismos tres usuarios en la tabla pg_shadow, el problema
es que no he podido hacer el backup y ya no tengo espacio en la
particion donde tengo montada la base






In response to

pgsql-docs by date

Next:From: Ray StellDate: 2007-03-24 02:04:34
Subject: Re: no verification of client certificate?
Previous:From: Tom LaneDate: 2007-03-23 22:01:17
Subject: Re: no verification of client certificate?

pgsql-admin by date

Next:From: Daniel Ricardo MedinaDate: 2007-03-23 23:37:57
Subject: AYUDA URGENTE CON TABLA PG_SHADOW
Previous:From: Warren LittleDate: 2007-03-23 23:16:08
Subject: trying to run PITR recovery

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