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>