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

From: Vibhor Kumar <vibhor(dot)kumar(at)enterprisedb(dot)com>
To: Leo <fleovey(at)saij(dot)jus(dot)gov(dot)ar>
Cc: <pgsql-novice(at)postgresql(dot)org>
Subject: Re: postgres 9.0.3 unable to connect using DBD::Pg 2.17.2
Date: 2011-03-16 22:03:10
Message-ID: F0B51ABC-8714-4CE0-890A-6B48CEA04691@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice


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 line 27.

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(dot)kumar(at)enterprisedb(dot)com
Blog:http://vibhork.blogspot.com

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Rex Hu 2011-03-17 04:01:08 How to add a new field/column in a table
Previous Message aaronenabs 2011-03-16 18:19:38 Accessing dead rows within postgresql