Re: dblink connect per socket / specify cluster name - Mailing list pgsql-general

From Magnus Hagander
Subject Re: dblink connect per socket / specify cluster name
Date
Msg-id CABUevEyty5Vm5rHVsnepH8ztbektTXdXapC5NYs9tRyb87=HgQ@mail.gmail.com
Whole thread Raw
In response to dblink connect per socket / specify cluster name  (james garner <jamgarn@gmail.com>)
List pgsql-general


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

pgsql-general by date:

Previous
From: james garner
Date:
Subject: dblink connect per socket / specify cluster name
Next
From: "Sterpu Victor"
Date:
Subject: Re: Unique index problem