Re: how to recover superuser password ? - Mailing list pgsql-novice

From Patrick
Subject Re: how to recover superuser password ?
Date
Msg-id 20021202165339.GI28102@nohope.patoche.org
Whole thread Raw
In response to Re: how to recover superuser password ?  (Joel Burton <joel@joelburton.com>)
List pgsql-novice
On Mon, Dec 02, 2002 at 11:42:25AM -0500, Joel Burton took time to write:
> Change your pg_hba.conf to allow connections from the localhost as
> "trust" (then kill -HUP the postmaster to notice the changes here).
> Log in from localhost (you won't be prompted for a
> password). Now you can change your password.

Joel, thanks a lot !

The solution was obvious, I am an idiot.

Patrick.

pgsql-novice by date:

Previous
From: Malcolm Hutty
Date:
Subject: "next"
Next
From: David C.Oshel
Date:
Subject: Installing readline, compiling 7.3 on Mac OS X 10.2.2