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
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend