How to reset PostgreSQL password

WAS THIS PAGE HELPFUL? {html}<a href="mailto:training@gwos.com?subject=How to reset PostgreSQL password">Leave Feedback</a>{html}\\
\\

h5. Overview

Follow the steps below to reset your PostgreSQL root user password.

# Stop gwservices:
{noformat}/etc/init.d/groundwork stop gwservices{noformat}
# Stop httpd:
{noformat}/etc/init.d/groundwork stop apache{noformat}
# Update the the following file to trust for local connections:
{noformat}vi /usr/local/groundwork/postgresql/data/pg_hba.conf{noformat}
Example:
{noformat}# TYPE DATABASE USER ADDRESS METHOD
host all all 127.0.0.1/32 trust{noformat}
# Restart postgres:
{noformat}/etc/init.d/groundwork restart postgresql{noformat}
# Open a {{psql}} session as the {{postgres}} user (you won't be asked for the password under TRUST authentication) to the database:
{noformat}psql{noformat}
# Execute the command (leave quotes):
{noformat}ALTER USER postgres WITH PASSWORD '<newpassword>';{noformat}
# Leave the session:
{noformat}\q{noformat}
# Undo the settings to trust in the file:
{noformat}vi /usr/local/groundwork/postgresql/data/pg_hba.conf{noformat}
Example:
{noformat}# TYPE DATABASE USER ADDRESS METHOD
host all all 127.0.0.1/32 md5{noformat}
# Restart gwservices:
{noformat}/etc/init.d/groundwork restart gwservices{noformat}
# Restart httpd:
{noformat}/etc/init.d/groundwork restart apache{noformat}
# Restart postgres:
{noformat}/etc/init.d/groundwork restart postgresql{noformat}
# You should now be able to connect using the new password, you can test by entering {{psql}}.