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'
**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.
Thanks for writing back. I am still not able to configure the Post GRE. Would appreciate any help in resolving the same. I am working with the PVS for LSA that is provided as a part of the couse. I have installed the PVS on my Windows 10 laptop. I have installed PostgreSql 9.1 in my Windows10 laptop and I am trying to add a server by clicking on File->Add Server. I am giving the details as Host = my IP address with which i can access the Designer Studio, port as 5432, username as postgres and password as postgres.
Please let me know what I need to do.
Do I need to install Postgre Sql 9.1 inside the PVS Linux box? If so, then what is the step for doing that?
The architecture is still not quite clear to me. I understand that PVS is running LINUX.
It has the below configuration for Application server.
Application Server: Apache Tomcat/7.0.53
Server IP address: 192.168.56.103
Server port: 9080
And it has a DataBase installed inside the PVS. I am trying to add an admin tool to connect to the DB.
As delivered the Postgres DB running within the PVS does not allow external connections. Copy the script below to a file, then use WinSCP to send it to root/install's home directory on the PVS. Then execute the script from the command line using: bash ./AllowExternalDBConnections.sh
For simplicity on Windows you can define "vapp" in C:\WIndows\System32\Drivers\etc\hosts" as 192.168.56.103.
Use any tool you want on your WIndows laptop to connect to the DB, for example Squirrel or the pgAdmin3 app that comes with a Personal Edition.
On the PVS look at /opt/tomcat/conf/context.xml for database port, user, and password information.
9080 is the port used to connect to Tomcat on the PVS, A different port number is used to connect to the Postgres DB.