在Ubuntu 11.04服务器中为postgresql启用PHP支持

sudo apt-get update
sudo apt-get upgrade

sudo apt-get install php5 php5-cli php5-common

sudo apt-get install php5-pgsql

sudo /etc/init.d/apache2 restart

<?php
$dbhost = 'localhost';
$dbname = 'your_database_name';
$dbuser = 'your_database_user';
$dbpass = 'your_database_password';

$conn = pg_connect("host=$dbhost dbname=$dbname user=$dbuser password=$dbpass")
    or die('Could not connect: ' . pg_last_error());

echo "Connected to PostgreSQL database!";

pg_close($conn);
?>