[pgpool-general: 1187] Re: how to force pgpool to bind to a specific network interface
Lonni J Friedman
netllama at gmail.com
Mon Nov 19 23:57:07 JST 2012
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).
More information about the pgpool-general
mailing list