[pgpool-general: 1187] Re: how to force pgpool to bind to a specific network interface

[Lonni J Friedman]

On Sun, Nov 18, 2012 at 10:12 PM, Tatsuo Ishii <ishii at postgresql.org> wrote:
>>>> I'm running version 3.2.1 on a Linux server with multiple network
>>>> interfaces.  My postgresql servers have pg_hba.conf configured such
>>>> that connections are only permitted from the IP address associated
>>>> with one of the network interfaces on the pgpool server.  Thus, I need
>>>> pgpool to bind to that specific network interface, and not any of the
>>>> others at random.
>>>>
>>>> I thought maybe I could set listen_addresses to do this, but that only
>>>> seems to effect which IP pgpool is listening on, and apparently not
>>>> the one that its connecting to the servers.  How can I fix this?
>>>
>>> Can't you login a desired IP host then start pgpool?
>>
>> Sorry, I don't understand what you mean by "login a desired IP host" ?
>
> You have a machine which two (or more) network interfaces. Each
> interface is assigned different IP. By login to one of IP, the kernel
> assigns source IP which you logged in to, I thought.

That isn't the problem that I need to solve.  I need pgpool to connect
to the postgresql database servers from a specific IP address on the
pgpool server, which has multiple network interfaces (and IP
addresses).