public inbox for [email protected]  
help / color / mirror / Atom feed
From: Daniel Ricardo Medina <[email protected]>
To: [email protected]
Cc: [email protected]
Subject: Re: no verification of client certificate?
Date: Fri, 23 Mar 2007 18:19:03 -0500
Message-ID: <873F3E256E0BF14EA84EAC54C2886B5D0B982E@computecnew.redcorp.computec.com> (raw)
In-Reply-To: <[email protected]>

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








view thread (14+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: no verification of client certificate?
  In-Reply-To: <873F3E256E0BF14EA84EAC54C2886B5D0B982E@computecnew.redcorp.computec.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox