Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Sudipta Biswas (Sudipta1986)
CGI

CGI
CA
Sudipta1986 Member since 2016 8 posts
CGI
Posted: Mar 13, 2018
Last activity: Aug 26, 2020
Posted: 13 Mar 2018 20:48 EDT
Last activity: 26 Aug 2020 8:41 EDT
Closed
Solved

Unable to connect to the SSA7.3 postgres DB

Hi,

I could not connect to the DB using postgres. I am using the following password provided with the PVS:

Database Information

Pega Academy recommends PGAdmin (link opens in a new window) as the preferred tool for database administration.

  • Database: PostgreSQL 9.2
  • User Name: postgres
  • Password: postgres

I am getting the below error:

Unable to connect to server:

FATAL: password authentication failed for user "postgres"

To see attachments, please log in.
Pega Academy

  • Dondla Satish

Accepted Solution

Posted: 6 years ago
Posted: 15 Mar 2018 5:09 EDT
Marco Duizer (duizm)
PEGA
Technical Solutions Director
Pegasystems Inc.
NL

If you get an error then you need to edit a file in the VM:

*/

Modify /var/lib/pgsql/9.4/data/pg_hba.conf and add the following line:

     host    all    all    Proprietary information hidden/0    trust

Save the changes and restart the Database Server.

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