Thread: dblink connect per socket / specify cluster name

On Dec 21, 2015 08:58, "james garner" <jamgarn@gmail.com> wrote:
>
> Dear list,
>
> i'm running PgSQL 9.3 on Debian installed from the Debian packets.
> I'm using dblink to access a different database.
> When im trying to connect to the database by socket via
> dblink_exec('dbname=test host=/var/run/postgresql' ..
> everything works nicely if there's just one db-cluster named 'main'
> I didn't find a way however to select a different cluser name.
> If a connection is made by TCP, the cluster ist determined by the port, but how is it done when connecting by socket?

It's still determined by the port. Set the host name to the directory where the sockets are, and the port number will control the actual socket name.

/Magnus