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: 7 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.

Related content:

Related content has not currently been identified for this post.

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