Re: forgot password to postgresql

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: Phil Stepanov <phstepanov(at)gmail(dot)com>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: forgot password to postgresql
Date: 2010-06-05 16:29:15
Message-ID: 4C0A7B5B.5000205@lelarge.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Le 05/06/2010 14:54, Phil Stepanov a écrit :
> Hello. Help me please. I can not log in to my database using pgadmin
> III. The program require a password. I unfortunately forgot it. How can
> I restore it or somewhere to see?

You cannot see it. You need to connect to your database to change it.
So, the simplest way is to change the authentication method with trust.
Then connect to the database, change your password with the ALTER USER
statement. Then change back the authentication method.

--
Guillaume
http://www.postgresql.fr
http://dalibo.com

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Guillaume Lelarge 2010-06-05 21:10:34 Re: beta testing - pgAdmin crash on macosx 10.5.8
Previous Message Phil Stepanov 2010-06-05 12:54:48 forgot password to postgresql