Skip to main content

Question

 Sivaramireddy Taniparthi (SivaramireddyT2951) Coforge
Coforge
IN
SivaramireddyT2951 Member since 2015 5 posts
Coforge
Posted: Jun 12, 2024
Last activity: Jun 13, 2024
Posted: 12 Jun 2024 5:22 EDT
Last activity: 13 Jun 2024 0:22 EDT
Solved

How to reset the postgres password

How to reset the postgres password. When I'm resetting the password I'm getting an error. Please see the attached screenshot. Help me on this.Postgres

To see attachments, please log in.
Pega Platform Pega Academy

  • Reply

Accepted Solution

Posted: 2 months ago
Updated: 2 months ago
Posted: 12 Jun 2024 8:42 EDT
Updated: 13 Jun 2024 0:22 EDT
Ankitha Reddy Raula (AnkithaReddyR) Eclatprime Digital Private Limited Technical Lead
Eclatprime Digital Private Limited
AU

@SivaramireddyT2951

 

Hi.to reset the postgres pssword you can check and modify the authentication configuration in the pg_hba.conf file located in the PostgreSQL data directory. Open the pg_hba.conf file and update the method to the following:

file

after updating restart the postgres server and try to login and update the password. once password updation is complete open the pg_hba.conf change the method to as is and save the file,and restart the server then login with new password.

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice