dblink connect per socket / specify cluster name
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?
Thanks
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