Re: dblink connect per socket / specify cluster name

Поиск
Список
Период
Сортировка
От Magnus Hagander
Тема Re: dblink connect per socket / specify cluster name
Дата
Msg-id CABUevEyty5Vm5rHVsnepH8ztbektTXdXapC5NYs9tRyb87=HgQ@mail.gmail.com
обсуждение исходный текст
Ответ на dblink connect per socket / specify cluster name  (james garner <jamgarn@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: james garner
Дата:
Сообщение: dblink connect per socket / specify cluster name
Следующее
От: "Sterpu Victor"
Дата:
Сообщение: Re: Unique index problem