Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id EC4192E00CC for ; Sat, 26 Apr 2008 10:03:17 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 49655-03 for ; Sat, 26 Apr 2008 10:03:06 -0300 (ADT) X-Greylist: delayed 00:06:40.822797 by SQLgrey-1.7.5 Received: from qmail01.contegix.com (ns2.contegix.com [63.246.22.100]) by developer.postgresql.org (Postfix) with ESMTP id 671FA2E00CB for ; Sat, 26 Apr 2008 10:03:14 -0300 (ADT) Received: (qmail 14726 invoked by uid 89); 26 Apr 2008 12:56:31 -0000 Received: from unknown (HELO mail.contegix.com) (63.246.22.119) by a.mx.contegix.com with SMTP; 26 Apr 2008 12:56:31 -0000 Received: from localhost (localhost.localdomain [127.0.0.1]) by mail.contegix.com (Postfix) with ESMTP id EACE7D7402C for ; Sat, 26 Apr 2008 07:56:31 -0500 (CDT) Received: from mail.contegix.com ([127.0.0.1]) by localhost (mail.contegix.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id Ntw9fnDhiS2D for ; Sat, 26 Apr 2008 07:56:30 -0500 (CDT) Received: from [10.10.161.100] (seraph.contegix.com [63.246.22.126]) by mail.contegix.com (Postfix) with ESMTP id 66E1DD7402B for ; Sat, 26 Apr 2008 07:56:30 -0500 (CDT) Message-Id: From: Craig McElroy To: pgsql-admin@postgresql.org In-Reply-To: <20080426123413.GA4035@cns.vt.edu> Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes Content-Transfer-Encoding: 7bit Mime-Version: 1.0 (Apple Message framework v919.2) Subject: Re: Forgot Root Password Date: Sat, 26 Apr 2008 07:56:30 -0500 References: <4478b4ac0804252230u5eb1a7f4k5878eb11b8611765@mail.gmail.com> <20080426123413.GA4035@cns.vt.edu> X-Mailer: Apple Mail (2.919.2) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200804/261 X-Sequence-Number: 29025 Also, if you wish to avoid a full restart of the database, this change would be picked up by a "pg_ctl reload" as well. Cheers, -craig --- Craig A. McElroy Contegix LLC Beyond Managed Hosting(r) for Your Enterprise On Apr 26, 2008, at 7:34 AM, Ray Stell wrote: > 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. > > -- > Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-admin