Search Postgresql Archives

Re: dblink connect per socket / specify cluster name

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




On Dec 21, 2015 08:58, "james garner" <jamgarn@xxxxxxxxx> 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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux