Postgres Pro
Downloads
Home   >   mailing lists

Re: postgres 9.0.3 unable to connect using DBD::Pg 2.17.2 - Mailing list pgsql-novice

From Vibhor Kumar
Subject Re: postgres 9.0.3 unable to connect using DBD::Pg 2.17.2
Date
Msg-id F0B51ABC-8714-4CE0-890A-6B48CEA04691@enterprisedb.com
Whole thread Raw
In response to postgres 9.0.3 unable to connect using DBD::Pg 2.17.2  ("Leo" <fleovey@saij.jus.gov.ar>)
List pgsql-novice
Tree view 
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

pgsql-novice by date:

Previous
From: aaronenabs
Date:
Subject: Accessing dead rows within postgresql
Next
From: Rex Hu
Date:
Subject: How to add a new field/column in a table