Return to Answer

From the 9.0 FAQ, I lost the database password. What can I do to recover it?:

I lost the database password. What can I do to recover it?

 

You can't. However, you can reset it to something else. To do this, you

 

1. Edit pg_hba.conf to allow trust authorization temporarily - go here for its location
2. Reload the config file (pg_ctl reload)
3. Connect and issue ALTER ROLE postgres WITH PASSWORD 'newpassword'; to set the new password (for first time users note the semi-colon)
4. Edit pg_hba.conf again and restore the previous settings
5. Reload the config file again

From the 9.0 FAQ, I lost the database password. What can I do to recover it?:

I lost the database password. What can I do to recover it?

You can't. However, you can reset it to something else. To do this, you

1. Edit pg_hba.conf to allow trust authorization temporarily - go here for its location
2. Reload the config file (pg_ctl reload)
3. Connect and issue ALTER ROLE postgres WITH PASSWORD 'newpassword'; to set the new password (for first time users note the semi-colon)
4. Edit pg_hba.conf again and restore the previous settings
5. Reload the config file again

From the 9.0 FAQ, I lost the database password. What can I do to recover it?:

I lost the database password. What can I do to recover it?

You can't. However, you can reset it to something else. To do this, you

1. Edit pg_hba.conf to allow trust authorization temporarily
2. Reload the config file (pg_ctl reload)
3. Connect and issue ALTER ROLE postgres WITH PASSWORD 'newpassword'; to set the new password (for first time users note the semi-colon)
4. Edit pg_hba.conf again and restore the previous settings
5. Reload the config file again

From the 9.0 FAQ, I lost the database password. What can I do to recover it?:

I lost the database password. What can I do to recover it?

You can't. However, you can reset it to something else. To do this, you

1. Edit pg_hba.conf to allow trust authorization temporarily - go here for its location
2. Reload the config file (pg_ctl reload)
3. Connect and issue ALTER ROLE postgres WITH PASSWORD 'newpassword'; to set the new password (for first time users note the semi-colon)
4. Edit pg_hba.conf again and restore the previous settings
5. Reload the config file again

I lost the database password. What can I do to recover it?:

I lost the database password. What can I do to recover it?

You can't. However, you can reset it to something else. To do this, you

1. Edit pg_hba.conf to allow trust authorization temporarily
2. Reload the config file (pg_ctl reload)
3. Connect and issue ALTER ROLE / PASSWORD to set the new password
4. Edit pg_hba.conf again and restore the previous settings
5. Reload the config file again

From the 9.0 FAQ, I lost the database password. What can I do to recover it?:

I lost the database password. What can I do to recover it?

You can't. However, you can reset it to something else. To do this, you

1. Edit pg_hba.conf to allow trust authorization temporarily
2. Reload the config file (pg_ctl reload)
3. Connect and issue ALTER ROLE postgres WITH PASSWORD 'newpassword'; to set the new password (for first time users note the semi-colon)
4. Edit pg_hba.conf again and restore the previous settings
5. Reload the config file again