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

postgres 9.0.3 unable to connect using DBD::Pg 2.17.2

From
"Leo"
Date:

postgres 9.0.3 I am unable to connect from DBD::Pg 2.17.2

I have switched to Postgres 9.0.3 runing on an Ubuntu server 10.10 (latest version)
 
I tried to changed all the pg_hba.conf host and local to trust but no luck
Also tried older version of DBD::Pg with no luck
 
Because of this the Perl applications cannot acces de databases - it worked fine on previous releases.
 
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 line 27.
 
The database is running OK and is accessible thru PgAdmin3 with no problem
 
Please help.



__________ Información de ESET NOD32 Antivirus, versión de la base de firmas de virus 5957 (20110316) __________

ESET NOD32 Antivirus ha comprobado este mensaje.

http://www.eset.com

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

From
Vibhor Kumar
Date:
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