Re: Forgot Password

There is no way to reset the password without logging into the host resetting the password  if there is no other superuser or other high level role to login as..

If this is a Linux box sudo as postgres then psql  the default configuration is trust Unix Sockets,  then can reset the password.
have to have sudo powers to become postgres...  have to have sudo powers to modify the pg_hba.conf file  then reload the config..

sudo -iu postgres
psql 
\password <username> 

Windows this is bit harder,  best add localhost trust entry into the pg_hba.conf  then reload the configuration

psql -h localhost -U postgres  -d postgres
\password <username>

Hope this helps

Thanks
Justin