Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 3D9069FB60F; Sun, 18 Feb 2007 20:55:44 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 85410-08; Sun, 18 Feb 2007 20:55:29 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from actenon.computec.com.co (actenon.computec.com.co [200.74.143.146]) by postgresql.org (Postfix) with SMTP id 277E19FB3AF; Sun, 18 Feb 2007 20:55:39 -0400 (AST) Received: from computecnew.redcorp.computec.com ([172.24.10.109]) by actenon.computec.com.co (SMSSMTP 4.1.11.41) with SMTP id M2007021819543625755 ; Sun, 18 Feb 2007 19:54:36 -0500 Received: from dmedina.redcorp.computec.com ([172.24.33.42]) by computecnew.redcorp.computec.com with Microsoft SMTPSVC(6.0.3790.1830); Sun, 18 Feb 2007 19:56:53 -0500 Subject: Re: [pgsql-es-ayuda] tabla pg_user Ayuda...... From: Daniel Medina To: Alvaro Herrera Cc: Jaime Casanova , pgsql-es-ayuda@postgresql.org, pgsql-admin@postgresql.org In-Reply-To: <20070215134933.GB4682@alvh.no-ip.org> References: <45D496E7.6040502@renova.com.pe> <1171056020.7776.27.camel@dmedina.redcorp.computec.com> <1171467067.3937.22.camel@localhost.localdomain> <20070215134933.GB4682@alvh.no-ip.org> Content-Type: text/plain; charset=utf-8 Date: Sun, 18 Feb 2007 19:56:27 -0500 Message-Id: <1171846587.3933.38.camel@dmedina.redcorp.computec.com> Mime-Version: 1.0 X-Mailer: Evolution 2.0.2 (2.0.2-22) Content-Transfer-Encoding: quoted-printable X-OriginalArrivalTime: 19 Feb 2007 00:56:53.0715 (UTC) FILETIME=[D8A95230:01C753C0] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=BAYES_50 X-Spam-Level: X-Archive-Number: 200702/266 X-Sequence-Number: 24731 esto tratando de hacer los que dices abajo=20 borrar el usuario , los cree pero nuevamente me crea dos registros select * from pg_user; 1: usename (typeid =3D 19, len =3D 64, typmod =3D -1, byval = =3D f) 2: usesysid (typeid =3D 23, len =3D 4, typmod =3D -1, byval =3D= t) 3: usecreatedb (typeid =3D 16, len =3D 1, typmod =3D -1, byval =3D= t) 4: usesuper (typeid =3D 16, len =3D 1, typmod =3D -1, byval =3D= t) 5: usecatupd (typeid =3D 16, len =3D 1, typmod =3D -1, byval =3D= t) 6: passwd (typeid =3D 25, len =3D -1, typmod =3D -1, byval = =3D f) 7: valuntil (typeid =3D 702, len =3D 4, typmod =3D -1, byval = =3D t) 8: useconfig (typeid =3D 1009, len =3D -1, typmod =3D -1, byval = =3D f) ---- 1: usename =3D "postgres" (typeid =3D 19, len =3D 64, typmo= d =3D -1, byval =3D f) 2: usesysid =3D "1" (typeid =3D 23, len =3D 4, typmod =3D -1, byval =3D t) 3: usecreatedb =3D "t" (typeid =3D 16, len =3D 1, typmod =3D -1, byval =3D t) 4: usesuper =3D "t" (typeid =3D 16, len =3D 1, typmod =3D -1, byval =3D t) 5: usecatupd =3D "t" (typeid =3D 16, len =3D 1, typmod =3D -1, byval =3D t) 6: passwd =3D "********" (typeid =3D 25, len =3D -1, typmod =3D -1= , byval =3D f) ---- cree un usuario como usesyid =3D 1 y trate de borrar el usuario postgres pero no hace nada..=20 que comandos debo utilizar=20 Gracias ... El jue, 15-02-2007 a las 10:49 -0300, Alvaro Herrera escribi=C3=B3: > Jaime Casanova escribi=C3=B3: >=20 > > Alvaro, un vacuum como superusuario podria haber arreglado algo? o > > hubiera tenido que borrar la tupla que pareciera mas vieja? o ninguna > > de ambas podria haber funcionado? estoy asumiendo que el problema es > > el que mencione arriba, no se me ocurre que mas pudo ser... >=20 > La verdad es que no estoy 100% seguro porque no sabemos en que estado > estaban esas tuplas ... pero hace un tiempo le hice una consultoria a > una empresa que tuvo un problema muy similar, y cuando les dije que > hicieran un VACUUM sobre pg_shadow, no tuvo el resultado esperado. >=20 > Lo malo fue que hicimos un DELETE del usuario repetido, con el mismo > resultado: se borraron las dos tuplas :-) y no habia forma de volver a > crearlo. >=20 > Asi que lo que hicimos fue bajar el postmaster, abrir un proceso > standalone, crear el usuario nuevamente, volver a levantar postmaster. >=20 --=20 Daniel Ricardo Medina R. Ing. de Desarrollo Computec S.A. - Documentos tel: 2607111 ext. 140