Thread: resetting postgres password

resetting postgres password

From
D A GERM
Date:
What is the easiest way to reset the postgres user password?

Re: resetting postgres password

From
John DeSoi
Date:
On Apr 6, 2005, at 8:22 AM, D A GERM wrote:

> What is the easiest way to reset the postgres user password?

Using the ALTER USER command. If you don't know the password,
temporarily modify the pg_hba.conf file to allow local connections
without a password ('trust'). You can then login without the password
and reset it.


John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL