pg_connect problem

["Edric Bulalacao" <egb@xxxxxxxxxxxx>]

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.