Question

14
Replies
7039
Views
AniruddhaS6920 Member since 2012 1 post
Bank of America
Posted: June 6, 2016
Last activity: October 4, 2018
Closed
Solved

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:https://pdn.pega.com/forums/lead-system-architect-71/pega-717-pvs-database-connection-details

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 ./pgEnable.sh

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 "./pgEnable.sh: 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
Share this page LinkedIn