## machine info

[root@VIRTCENT09:~] #cat /etc/redhat-release
CentOS release 5.6 (Final)

[root@VIRTCENT09:~] #uname -a
Linux VIRTCENT09.summitnjhome.com 2.6.18-238.el5xen #1 SMP Thu Jan 13 17:49:40 EST 2011 i686 i686 i386 GNU/Linux


## postgres version


psql (PostgreSQL) 8.4.8
contains support for command-line editing


## drupal database


  Name    |  Owner   | Encoding |  Collation  |    Ctype    |   Access privileges
-----------+----------+----------+-------------+-------------+-----------------------
 drupal    | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 |
 forums    | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 |
 postgres  | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 |
 template0 | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/postgres
                                                             : postgres=CTc/postgres
 template1 | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/postgres
                                                             : postgres=CTc/postgres
(5 rows)


## php can connect to pgsql from web server


[root@VIRTCENT07:/home/bluethundr/php] #cat connect.php
<?php
 if ($dbconn = pg_connect("host=db1 dbname=drupal port=5432 user=drupaladmin password=secret")) echo "Great success!!\n";
?>


[root@VIRTCENT07:/home/bluethundr/php] #php connect.php
Great success!!