Code for test_db.php
<html>
<body>
<pre>
<?php
include 'DBVars.php';
echo 'Is extension pgsql loaded: ' . (extension_loaded('pgsql') ? 'yes':'no') . ' (if "no" pg_connect will fail' . ")\n";
echo "trying to make a connction, using:\n";
echo ">" . $gDB_conn_string . "<\n";
echo " host: >" . $gDB_host . "<\n";
echo " dbname: >" . $gDB_name . "<\n";
echo " port: >" . $gDB_port . "<\n";
echo " user: >" . $gDB_user . "<\n";
echo " password: >" . $gDB_password . "<\n";
$dbconn = pg_connect($gDB_conn_string)
or die('Could not connect ' . pg_last_error());
$v = pg_version($dbconn);
echo "It worked! A connection was makde to the database. psql version:" . $v['client'];
?>
</pre>
</body>
</html>