Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 9C3442E00B6 for ; Fri, 22 Feb 2008 01:06:42 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 04180-02 for ; Fri, 22 Feb 2008 01:06:36 -0400 (AST) Received: from wr-out-0506.google.com (wr-out-0506.google.com [64.233.184.239]) by postgresql.org (Postfix) with ESMTP id 619BC2E00B4 for ; Fri, 22 Feb 2008 01:06:37 -0400 (AST) Received: by wr-out-0506.google.com with SMTP id 71so516757wri.5 for ; Thu, 21 Feb 2008 21:06:36 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=1bp3RT6M8Tnngfoe6o9uynrWBDJWZZ4rcfKeaLvEnkc=; b=DiINJPxO2t1RL6/duEjBCOCzYML8efiqKaLd/Oa0aNWssRDJ9XZFJv2hxJrt6bKL4NfgT+LXc7NIrm3UhmjvFs81MAiSPKU2uzTYn72SDm6dvEIHwkG8P0Ta6yyGLPDe+fd7/cgrYD65G5JcaesmRvg+8gAfOtCSbKbNqBBmWYs= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=qL/Z6Y+USRIskMn/damTs5+P0LNP5ilydQ6U72yTYDSegwBoo4nP5Nv/dCKYUDiOSvWbE2jp1hmF72Zh8yOrq3vSHY8fzk2kfTz5XuOM36dxfUN9IrReXu4u6XcBWP2r0q5dFQEAKLP3MMxQQ7+amzigv24tbYujS/lr685+fdM= Received: by 10.114.95.1 with SMTP id s1mr1592997wab.99.1203656795161; Thu, 21 Feb 2008 21:06:35 -0800 (PST) Received: by 10.114.74.9 with HTTP; Thu, 21 Feb 2008 21:06:35 -0800 (PST) Message-ID: Date: Fri, 22 Feb 2008 00:06:35 -0500 From: "Jaime Casanova" To: "Wolfgang Rodriguez" Subject: Re: Clave usuario postgres Cc: pgsql-admin@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <238696420802192330g69e3c447jeadd1d3d31506eda@mail.gmail.com> <47BBDF78.7070801@Sheeky.Biz> <238696420802200115m522cfd11h2f37d87845c2d6e0@mail.gmail.com> <238696420802200219y7bfd4269u498dd1fe0b80c2cc@mail.gmail.com> <238696420802200311y40a93a38jbd601e280d2fb860@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/266 X-Sequence-Number: 28340 this is an english list, you can write in spanish at pgsql-es-ayuda@postgresql.org 2008/2/21 Wolfgang Rodriguez : > > > Saludos a todos. > > Se me presenta el siguiente problema: olvid=E9 y extravi=E9 la clave o pa= ssword > del usuario postgres y no puedo accesar las distintas bases de datos. > > Por favor, alguien sabe c=F3mo podr=EDa recuperar esta clave o password? > Me han dicho que si vuelvo a instalar la aplicaci=F3n, es decir, el manej= ador > de postgres, puedo perder toda la informaci=F3n de las bases de datos. > is this the password for the OS user "postgres" or the DB role "postgres"? if the former you tell that to your sysadmin in order to him to reset it... then change the pg_hba.conf file and put trust as the method authorization for local access or maybe sameuser then reset it with ALTER ROLE of course, you need access to the machine... --=20 Atentamente, Jaime Casanova "Programming today is a race between software engineers striving to build bigger and better idiot-proof programs and the universe trying to produce bigger and better idiots. So far, the universe is winning." Richard Cook