Recct Recct - 1 year ago 80
Perl Question

Perl DBI: connect to REMOTE PostgreSQL db still complains about local socket file

I'm trying to use

to connect to a remote PostgreSQL db.
My connect string:
"", $user, $pass
does resolve to '', swapping both to the IP or having only host=IP all result in

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 /usr/local/share/perl/5.10.1/DBIx/Class/Storage/ line 1489. at line 26

On this debian I don't have or want postgresql, I do have
however. And
says that I do have
(It didn't before I installed the library).

How can I find out what it's trying to do and do I need anything else installing? The server in question is configured to allow connections from
addresses which the machine running this code is on and I can connect to it with tools such as PSequel and pgAdmin on my workstation (same network) with the db user in question.

Answer Source

That should be:


Only the first two separators are colons. The rest of them should be semi-colons.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download