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 admin password for the database. The > > original installer is no longer working here. Any way to find the admin > > password and or 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 -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
