Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group