On Thu, Aug 25, 2011 at 10:50:55PM +0200, Guillaume Lelarge wrote:
> On Thu, 2011-08-25 at 20:21 +0000, Cuddihy, Joe wrote:
> > Hello
> > We are trying to recover our postgres data base for the Avocent data center planner tool. We are in need of the
adminpassword for the database. The original installer is no longer working here. Any way to find the admin password
andor be able to change it.
> > Any help will be greatly appreciated.
> >
>
> You don't need the password. Change the authentication method to trust,
> reload PostgreSQL configuration, and you're done.
this is done in the file pg_hba.conf, in case you didn't know. there are
great security implications to doing this so read the doc before you pull
the trigger.
http://www.postgresql.org/docs/current/static/client-authentication.html