Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 60B3A9FBCDF; Wed, 14 Feb 2007 16:10:47 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 77747-03; Wed, 14 Feb 2007 16:10:39 -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 D83339FBC46; Wed, 14 Feb 2007 16:10:38 -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 M2007021415094711204 ; Wed, 14 Feb 2007 15:09:47 -0500 Received: from 172.24.33.42 ([172.24.33.42]) by computecnew.redcorp.computec.com with Microsoft SMTPSVC(6.0.3790.1830); Wed, 14 Feb 2007 15:12:12 -0500 Subject: Re: [pgsql-es-ayuda] tabla pg_user Ayuda...... From: Daniel Medina To: Alvaro Herrera Cc: pgsql-es-ayuda@postgresql.org, pgsql-admin@postgresql.org In-Reply-To: <20070214185212.GE16796@alvh.no-ip.org> References: <45D496E7.6040502@renova.com.pe> <1171056020.7776.27.camel@dmedina.redcorp.computec.com> <1171056070.7776.29.camel@dmedina.redcorp.computec.com> <1171469621.3937.30.camel@localhost.localdomain> <20070214185212.GE16796@alvh.no-ip.org> Content-Type: text/plain; charset=utf-8 Date: Wed, 14 Feb 2007 15:05:36 -0500 Message-Id: <1171483536.3937.41.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.0.2 (2.0.2-22) Content-Transfer-Encoding: quoted-printable X-OriginalArrivalTime: 14 Feb 2007 20:12:12.0474 (UTC) FILETIME=[69CBC9A0:01C75074] 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/205 X-Sequence-Number: 24670 Ok , pero si bajo y subo postgres sin el usuario admin no habra peligro que no suba... y si sube con que usuario haria el cambio... Gracias por tu colaboracion El mi=C3=A9, 14-02-2007 a las 15:52 -0300, Alvaro Herrera escribi=C3=B3: > Daniel Medina escribi=C3=B3: > > borre accidentalmente de la tabla pg_shadow el usurio postgres , > > existian dos registros de este usuario la diferencia era el pass > >=20 > > pero se borraron los dos=20 > >=20 > > al tratar de crearlo con create user=20 > > create user postgres with SYSID 1 password 'xxxx'; > > ERROR: must be superuser to create users > >=20 > >=20 > > o con el comando insert.. > >=20 > > insert into pg_shadow > > (usename,usesysid,usecreatedb,usesuper,usecatupd,passwd) values > > ('postgres',1,true,true,true,md5('*****')); > > ERROR: user with ID 1 does not exist >=20 > ja ja ja ... >=20 >=20 > Baja postmaster y levanta una sesion en modo standalone. Creo que es >=20 > postgres -P -O >=20 > (Mira postgres --help; depende de la version). >=20 > Ahi dentro puedes hacer el insert into pg_shadow, pero primero trata con > CREATE USER. >=20 --=20 Daniel Ricardo Medina R. Ing. de Desarrollo Computec S.A. - Documentos tel: 2607111 ext. 140