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

Tatsuo Ishii ishii at postgresql.org
Mon Nov 19 15:12:54 JST 2012

>>> 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.
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

More information about the pgpool-general mailing list