[Bucardo-general] problem with DBI connection

Greg Sabino Mullane greg at endpoint.com
Mon Dec 8 16:35:11 UTC 2014

On Fri, Dec 05, 2014 at 09:21:27AM +0800, Najwa Hasdi wrote:
> DBI connect('dbname=bucardo','bucardo',...) failed: 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"?

This seems to indicate that you have a mismatch in where  the socket directory 
is. Can you verify that the file /var/run/postgresql/.s.PGSQL.5432 does not 
exist? You may want to see if /tmp/.s.PGSQL.5432 exists, as /tmp is a more 
common socket directory than /var/run/postgresql.

If it *is* /tmp and not /var/run/postgresql, then you have to fix the mismatch 
somehow. Make sure no environment variables are pointing you there 
(esp. PGHOST). You could force it to behave by setting PGHOST to /tmp, 
but it would be better to figure out what is trying to set /var/run/postgresql 
first. Your best bet to unraveling this is to probably talk through 
it on the #postgresl channel on irc.freenode.net.

Greg Sabino Mullane greg at endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 163 bytes
Desc: Digital signature
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20141208/2d081ae1/attachment.sig>

More information about the Bucardo-general mailing list