Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 176079FBAD7; Wed, 14 Feb 2007 16:31:27 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 08234-08; Wed, 14 Feb 2007 16:30:55 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from lists.commandprompt.com (host-254.commandprompt.net [207.173.203.254]) by postgresql.org (Postfix) with ESMTP id AB1729FB9DC; Wed, 14 Feb 2007 16:30:57 -0400 (AST) Received: from perhan.alvh.no-ip.org (216-155-79-222.bk1-dsl.surnet.cl [216.155.79.222]) (authenticated bits=0) by lists.commandprompt.com (8.13.7/8.13.6) with ESMTP id l1EKUtMM028581; Wed, 14 Feb 2007 12:30:57 -0800 Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id B6C3D7DCA; Wed, 14 Feb 2007 17:30:51 -0300 (CLST) Date: Wed, 14 Feb 2007 17:30:51 -0300 From: Alvaro Herrera To: Daniel Medina Cc: pgsql-es-ayuda@postgresql.org, pgsql-admin@postgresql.org Subject: Re: [pgsql-es-ayuda] tabla pg_user Ayuda...... Message-ID: <20070214203051.GG16796@alvh.no-ip.org> Mail-Followup-To: Daniel Medina , pgsql-es-ayuda@postgresql.org, pgsql-admin@postgresql.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> <1171483536.3937.41.camel@localhost.localdomain> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <1171483536.3937.41.camel@localhost.localdomain> User-Agent: Mutt/1.5.13 (2006-08-11) X-Virus-Scanned: ClamAV version 0.88.5, clamav-milter version 0.88.5 on projects.commandprompt.com X-Virus-Status: Clean X-Greylist: Sender succeded SMTP AUTH authentication, not delayed by milter-greylist-1.6 (lists.commandprompt.com [192.168.2.159]); Wed, 14 Feb 2007 12:30:58 -0800 (PST) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.27 tagged_above=0 required=5 tests=AWL, BAYES_50, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200702/206 X-Sequence-Number: 24671 Daniel Medina escribió: > 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... El modo standalone no usa "un usuario", sino que automaticamente asume la identidad de un superusuario fijo. Puedes hacer el cambio sin restricciones. Postmaster puede subir sin ningun superusuario, asi que podras levantarlo despues aunque no arregles el problema. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc.