I’m a PHP/PostGRE newbie. I’m getting this error:
Warning: pg_connect(): Unable to connect to PostgreSQL server: could not connect to server: Connection refused Is the server running on host localhost and accepting TCP/IP connections on port 5432? . in /export/home/tsc/a/delete-action.phtml on line 156
Couldn't make a connection!
This is the code I’m trying to run:
$connection = pg_connect("host=localhost dbname=address user=address password=address");
This is my pg_hba.conf
local all all password
This is the output of “netstat –an | grep 5432”
unix 2 [ ACC ] STREAM LISTENING 27649 /tmp/.s.PGSQL.5432
I’m able to do “psql –u address” and supply and username and password as any Unix user defined in the system.
Can anyone tell me what I’m doing wrong? Thanks.