resetting postgres password

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