Thread: admin

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
passwordfor the database. The original installer is no longer working here. Any way to find the admin password and or
beable 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.


-- 
Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com

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