How do I reset the Postgres password?

Products

• CA Application Performance Management Agent (APM / Wily / Introscope)
• INTROSCOPE

Issue/Introduction

 Unable to start PostgreSQL Database after modifying the pg_hba.conf file.

 Seeing this error:
"Authentication option not in name=value format ":sameuser"

 

Environment

CA APM 10.x PostgreSQL 9.2

Resolution

The local flag is for local UNIX socket connections only. It may be that your psql connection is registering in some other way. To workaround this, change all host entries to trust instead of password.

Edit the file pg_hba.conf ( /POSTGRES_INSTALL/data/pg_hba.conf). This file controls which hosts are allowed to connect, how clients are authenticated, which PostgreSQL user names they can use, and which databases they can access. 

Records take one of these forms:

#
# local         DATABASE  USER  METHOD  [OPTIONS]
# host         DATABASE  USER  ADDRESS  METHOD  [OPTIONS]
# hostssl     DATABASE  USER  ADDRESS  METHOD  [OPTIONS]
# hostnossl  DATABASE  USER  ADDRESS  METHOD  [OPTIONS]
#

 

host all all 127.0.0.1/32 trust 
host all all 0.0.0.0/0 trust 
# IPv6 all connections: 
host all all ::/0 trust 

If all of the above entries are set to trust, then no connection should prompt for a password.  Make the above changes in the pg_hba.conf file.

This needs a recycle of PostgreSQL database after making the above changes.

 

 

Additional Information

Recover a lost or forgot Postgres password