pgadmin3 is installed. Try pega prpc/password as the user/pass.
To use pgadmin3 you would need to use an X server app on your laptop such as XMing http://sourceforge.net/projects/xming/, plus enable X11 forwarding in putty specifying “:0.0” as the X display location.
I am still facing issues in configuring the PgAdmin3 database for CSSA (v7.1) exercise system. I have Installed Xming server and configured Putty with X11 Forwarding enabled. I have attached the screenshot of error message. Please help me out with this.
This comment has been branched out as a new node and the new thread can be followed here
You do not need install Postgres on your laptop; it is much simpler to install a Pega 7 Personal Edition from PDN on your laptop and use its Postgres DB's pgAdmin3 client to connect to your VM Image's Postgres DB.
The key instructions to opening access to the VM image's DB connection are shown below:
Modify /etc/postgresql/9.1/main/postgresql.conf and add the following line:
listen_addresses = '*'
Save the changes.
Modify /etc/postgresql/9.1/main/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.
Below is a script that automates the above:
echo Fix RDBMS settings in your virtual machine
pg=`find / -mount -name postgresql.conf 2> /dev/null`
if [ -n "$pg" ]
echo Changing listening address for postgresql
grep "^listen_addresses = '\*'" $pg > /dev/null 2>&1 || echo "listen_addresses = '*'" >> $pg
echo Postgres.conf file not found
pg=`find / -mount -name pg_hba.conf 2> /dev/null`
if [ -n "$pg" ]
echo Changing host allowance for postgresql
grep "^host.*0\.0\.0\.0/0" $pg > /dev/null 2>&1 || echo "host all all 0.0.0.0/0 trust" >> $pg
echo applying md5 to peer authentication
sed -i "/^local.*all.*all.*peer$/s/peer/md5/g" $pg
echo postgres restart in 5 minutes. We wait 5 min so we not interfere with prpc startup.
echo service postgresql restart \> restart.res 2\>\&1 | at now + 5 min
echo Postgres pg_hba.conf file not found
The user/pass to the database is: prpc/password.
Either specify the IP address of your VM Image or alias that IP address within C:\Windows\System32\drivers\etc\hosts