Praveen John Kumar (johnp2)
Senior System Architect
Pegasystems Inc.
johnp2 Member since 2019 6 posts
Posted: September 15, 2019
Last activity: October 1, 2019
Posted: 15 Sep 2019 9:35 EDT
Last activity: 1 Oct 2019 23:39 EDT

Connect pgAdmin to Pega Database on Pega VM


Recently i had an issue while trying to connect pega database on pega VM to pgAdmin .

Solution :

There are 2 configuration files in /var/lib/pgsql/9.4/data folder within VM , where you might have to make changes to successfully connect .

  1. postgresql.conf - confirm -> listen_addresses=’*’
  2. pg_hba.conf - add -> host all all trust

Please see the screenshot for changes made on pg_hba.conf

Once the changes are made restart postgres server.

Note: if you are using Pega Academy VM , below are the credentials .

VM Console Login Credentials:

  • User Name: root
  • Password: install

Now able to connect pega database from VM to local pgAdmin below :

PostgreSQL Database Info and Credentials

User Password Description
postgres postgres Process owner for DB and Sys DBA
pega pega Pega Sys DBA

***Moderator Edit-Vidyaranjan: Updated content to remove proprietary information ***

System Administration Data Integration Developer Knowledge Share