Close popover
Aniruddha Sen (AniruddhaS6920)
Bank of America

Bank of America
AniruddhaS6920 Member since 2012 1 post
Bank of America
Posted: June 6, 2016
Last activity: October 4, 2018

Not able to conncet to postgres DB from Pega 7.1.9 PVS

Not able to connect to postgres db of Pega 7.1.9 PVS (CLSA 7.1 course), host = prpc, port = 5432, user = pega, password = pega

Have tried the followings as mentioned in the posts:

I used pgAdmin3.exe from my laptop's Personal Edition. host = prpc, user = prpc, password = password.

You can run the script below after which I recommend doing "Machine -> Reset" to 100% guarantee the database is restarted.

Use WinSCP.exe to copy the script to the PVS, naming it "pgEnable,sh", then make it executable using: chmod +x pgEnable,sh

After that execute the script using "sudo", for example, sudo ./

After execution of the script I can see pg_hba.conf & postgresql.conf are updated properly as per the script but also can see 1 error "./ line 33: at: command not found"

Have used pgAdmin3.exe and tried to connect with following credentials:host = prpc, port = 5432, user = pega, password = pega but getting error "couldn't translate hostname prpc to address, Unknown server error'

Any suggestion.

**Moderation Team has archived post**

This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.

Pega Academy
Moderation Team has archived post