Re: postgres 9.0.3 unable to connect using DBD::Pg 2.17.2

On Mar 16, 2011, at 10:35 PM, Leo wrote:

> ERROR MESSAGE:
>
> could not connect to server: No such file or directory
> Is the server running locally and accepting
> connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"? at /var/www/cgi-bin/Administrabase/pidebase.pl
line27. 

Message shows that DBD is looking for socket file in /var/run/postgresql/

Try following:
set following parameter in postgresql.conf file:
unix_socket_directory='/var/run/postgresql'

and restart the PG.

Thanks & Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
vibhor.kumar@enterprisedb.com
Blog:http://vibhork.blogspot.com