Thread: admin

admin

From
"Cuddihy, Joe"
Date:
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.
 
Joseph Cuddihy
Operations Analyst- Infrastructure
11045 East Lansing Circle
Englewood, CO 80112
Phone 720-875-7718
 

Re: admin

From
Guillaume Lelarge
Date:
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



Re: admin

From
Ray Stell
Date:
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