So I compiled pdo_pgsql from source and added the extension to my php.ini
phpinfo()
says
PDO
PDO support enabled
PDO drivers mysql, sqlite, pgsql
pdo_pgsql
PDO Driver for PostgreSQL enabled
PostgreSQL(libpq) Version 9.4.2
Module version 1.0.2
but
pg_connect("host=localhost dbname=dbname user=username password=password")
gives
Call to undefined function pg_connect()
Yes, I did restart apache.
SERVER_SOFTWARE Apache/2.4.10 (Unix) PHP/5.5.20
I am on Mac OS X Yosemite 10.10.3
Thanks!
How about make your connection like so:
try {
$conn = new PDO('pgsql:host=localhost;port=port-number;dbname=database','db-user','db-pass');
$conn->query("SET NAMES UTF8");
} catch (PDOException $e) {
die('Connection failed: ' . $e->getMessage());
}