Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id EE3102E006B for ; Sat, 26 Apr 2008 14:21:47 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 01962-02 for ; Sat, 26 Apr 2008 14:21:45 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by developer.postgresql.org (Postfix) with ESMTP id 4C8342E006A for ; Sat, 26 Apr 2008 14:21:45 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id m3QHLg71013089; Sat, 26 Apr 2008 13:21:42 -0400 (EDT) To: Ray Stell cc: Kranti K K Parisa? , pgsql-admin@postgresql.org Subject: Re: Forgot Root Password In-reply-to: <20080426123413.GA4035@cns.vt.edu> References: <4478b4ac0804252230u5eb1a7f4k5878eb11b8611765@mail.gmail.com> <20080426123413.GA4035@cns.vt.edu> Comments: In-reply-to Ray Stell message dated "Sat, 26 Apr 2008 08:34:13 -0400" Date: Sat, 26 Apr 2008 13:21:42 -0400 Message-ID: <13088.1209230502@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200804/263 X-Sequence-Number: 29027 Ray Stell writes: > On Sat, Apr 26, 2008 at 11:00:35AM +0530, Kranti K K Parisa? wrote: >> Can anyone suggest a way to retrieve/update the postgres root password ? > edit pg_hba.conf so that localhost connections from localhost are > trusted maybe like this: > host all all 127.0.0.1/32 trust > you have to restart, but then you can do an alter user and so can all > the other local users. "ident" mode might be a safer option. regards, tom lane