Question
1
Replies
326
Views
CGI
Posted: March 13, 2018
Last activity: August 26, 2020
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"
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 0.0.0.0/0 trust
Save the changes and restart the Database Server.