For some reason my post for how to connect using Squirrel did not "take".

That post mentioined that I cannot paste images into this forum -- you have to imagine them below.

Here is the text version again:

8>< - - - - Squirrel - - - - - ><8

Database connection information can be found in Tomcat’s conf directory’s context.xml file.
<!-- PostgreSQL 9.1 -->
<Resource name="jdbc/PegaRULES"
auth="Container"
type="javax.sql.DataSource"
driverClassName="org.postgresql.Driver"
url="jdbc:postgresql://localhost:5432/pega"
username="prpc"
password="password"
maxActive="100"
maxIdle="30"
maxWait="10000"/>

Note above that Tomcat is told that the Postgres database is one the same server, i.e., localhost. To you this is “prpc” as defined in your C:\Windows\System32\drivers\etc\hosts file. Example below.
    Proprietary information hidden     prpc                    # 7.1.7
    Proprietary information hidden     prpc62                # 6.2 PVS

The information needs to connect to any database using a JDBC thin driver is:

• Driver class:           org.postgresql.Driver
• JDBC URL:              jdbc:postgresql://prpc:5432/pega
• User:                       prpc
• Pass:                       password    

Next you need to locate a jar that contains the Postgres Driver class.  Go to https://jdbc.postgresql.org/.  Since version 9 of Postgres is used, click on  the “JDBC4” link. Example file name downloaded = postgresql-9.4-1201.jdbc4.jar. Place this jar in a well-known location, e.g., C:\717.

Next download the Squirrel Open Source Java application from http://www.squirrelsql.org/.  Extract to a directory such as C:\apps\Squirrel.
 

Be sure you have Java installed on your laptop and have JAVA_HOME defined.

Launch Squirrel, click on Drivers, click on Extra Class Path, navigate to the Postgres Driver jar than you downloaded, click Open, then click OK.
 
Next click on the Aliases tab, add supply the information below to connect to the 7.1.7 PVS.  As shown above, the password is simply “password”.

If you click “Connect” now, however, you will get an error.  The reason for this is that Postgres by default does not allow remote connections.

Using putty, log into your PVS,  then issue:   cd /etc/postgresql/9.1/main

Launch vi using:  sudo vi postgresql.conf

As shown below, add:   listen_addresses = '*'
 

Next execute:   sudo vi pg_hba.conf
As shown below, add:     host     all     all     Proprietary information hidden/0     trust
 
Finally, restart the Postgres DB.
    sudo /etc/init.d/postgresql stop
    sudo /etc/init.d/postgresql start

Try your Squirrel connection again.  This time it should work.

There are a few conditions you have to look at:

1. Ensure the database listens for connections from the outside world. That is done in the file postgresql.conf. Add listen_addresses = '*' to the end of this file if this text does not exist in the file.

You might need to search for that file in Linux (find / -mount -name postgresql.conf)

2. Ensure postgres allows logins from external computers. This is done in the file pg_hba.conf. Add "host  all  all  Proprietary information hidden/0  trust" to the end of the file and replace all occurence of "peer" with "md5" in the same file. You might need to search for that file in Linux (find / -mount -name ph_hba.conf)

3. Ensure SQuirreL can find the postgres jdbc driver. My postgres jdbc driver file is postgresql-9.2-1002.jdbc4.jar, but can be another version depending on what you did download. This is done onder the Drivers tab in Squirrel --> Extra Class Path.

PostGresql must now be restarted. Can be done in many ways, but a reboot of the virtual machine might be the easiest.

4. Make a connection configuration in SQuirreL to your database.

Enter jdbc:postgresql://<your hostname or IP>:5432/<your database name>

In my system this is jdbc:postgresql://prpc.:5432/pega but yours is probably different.

This is quite the same as Lee written above. If you still have problems you can reach out to me and I can try to help you remotely. ([email protected])

Just connected myself for the first time to the 7.1.7 VirtualBox 's postgres DB.

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

#! /bin/bash
#SuperUser=YES

echo
echo Fix RDBMS settings in your virtual machine
echo

pg=`find / -mount -name postgresql.conf 2> /dev/null`

if [ -n "$pg" ]
then
    echo
    echo Changing listening address for postgresql

    grep "^listen_addresses = '\*'" $pg > /dev/null 2>&1 || echo "listen_addresses = '*'"  >> $pg

else
    echo Postgres.conf file not found
fi

pg=`find / -mount -name pg_hba.conf 2> /dev/null`

if [ -n "$pg" ]
then
    echo Changing host allowance for postgresql

    grep "^host.*0\.0\.0\.0/0" $pg > /dev/null 2>&1 || echo "host  all  all   Proprietary information hidden/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

else
     echo Postgres pg_hba.conf file not found
fi

Step 1. Open WinSCP.exe

Step 2. Enter User/Password as root/install

Step 3. Change Directory >> cd /

Step 4. Create file pgEnable.sh in root directory and Copy Below Script 

#! /bin/bash
#SuperUser=YES

echo
echo Fix RDBMS settings in your virtual machine
echo

pg=`find / -mount -name postgresql.conf 2> /dev/null`

if [ -n "$pg" ]
then
    echo
    echo Changing listening address for postgresql

    grep "^listen_addresses = '\*'" $pg > /dev/null 2>&1 || echo "listen_addresses = '*'"  >> $pg

else
    echo Postgres.conf file not found
fi

pg=`find / -mount -name pg_hba.conf 2> /dev/null`

if [ -n "$pg" ]
then
    echo Changing host allowance for postgresql

    grep "^host.*0\.0\.0\.0/0" $pg > /dev/null 2>&1 || echo "host  all  all   Proprietary information hidden/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-9.3 restart \> restart.res 2\>\&1 | at now + 5 min

else
     echo Postgres pg_hba.conf file not found
fi

Step 5. Copy Change the Mode >> chmod +x pgEnable.sh

Step 6. Execute the script >> sudo ./pgEnable.sh

Step 7. Verification

After execution of the script check if following files are updated properly as below:

postgresql.conf  - > listen_addresses=’*’ (updated)
pg_hba.conf  - > host  all  all   Proprietary information hidden/0  trust (Added)

Step 8. Restart Postgres

cd /etc/init.d
sudo ./postgresql-9.3 restart

Step 9. Connect to Postgres

Host Name: <ip address>
Post: 5432
User Name: postgres
Password: postgres