Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id 7E78E2E0099 for ; Sat, 26 Apr 2008 09:34: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 44445-04 for ; Sat, 26 Apr 2008 09:34:06 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from locust.cns.vt.edu (locust.cns.vt.edu [198.82.169.14]) by developer.postgresql.org (Postfix) with ESMTP id 64F672E0098 for ; Sat, 26 Apr 2008 09:34:14 -0300 (ADT) Received: by locust.cns.vt.edu (Postfix, from userid 986) id 1725A118A6B; Sat, 26 Apr 2008 08:34:13 -0400 (EDT) Date: Sat, 26 Apr 2008 08:34:13 -0400 From: Ray Stell To: Kranti K K Parisa? Cc: pgsql-admin@postgresql.org Subject: Re: Forgot Root Password Message-ID: <20080426123413.GA4035@cns.vt.edu> References: <4478b4ac0804252230u5eb1a7f4k5878eb11b8611765@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <4478b4ac0804252230u5eb1a7f4k5878eb11b8611765@mail.gmail.com> User-Agent: Mutt/1.5.17 (2007-11-01) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200804/257 X-Sequence-Number: 29021 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.