Re: pgpool

On Mon, Jun 21, 2010 at 2:42 PM, Geoffrey <lists(at)serioustechnology(dot)com> wrote:
> Scott Marlowe wrote:
>>
>> On Mon, Jun 21, 2010 at 1:45 PM, Geoffrey <lists(at)serioustechnology(dot)com>
>> wrote:
>>>
>>> John R Pierce wrote:
>>>>
>>>> On 06/21/10 5:37 AM, Geoffrey wrote:
>>>>>
>>>>> So I've got 13 different databases on 13 different postmasters, now
>>>>> does
>>>>> pgpool know which databases I'm trying to connect to?
>>>>
>>>> you would need 13 different connection pools.
>>>
>>> Can this be done?
>>
>> Yes
>
> Can you point me to any docs that explain how this is done?  As there is
> only one pgpool.conf file, I'm wondering how to go about that process.

sudo apt-get install pgpool2
(password, yes, wait...)
pgpool --help
Usage:
pgpool [ -c] [ -f CONFIG_FILE ] [ -F PCP_CONFIG_FILE ] [ -a HBA_CONFIG_FILE ]
[ -n ] [ -d ]
pgpool [ -f CONFIG_FILE ] [ -F PCP_CONFIG_FILE ] [ -a HBA_CONFIG_FILE ]
[ -m SHUTDOWN-MODE ] stop
pgpool [ -f CONFIG_FILE ] [ -F PCP_CONFIG_FILE ] [ -a HBA_CONFIG_FILE ] reload

Common options:
-a HBA_CONFIG_FILE Sets the path to the pool_hba.conf configuration file
(default: /etc/pool_hba.conf)
-f CONFIG_FILE Sets the path to the pgpool.conf configuration file
(default: /etc/pgpool.conf)
-F PCP_CONFIG_FILE Sets the path to the pcp.conf configuration file
(default: /etc/pcp.conf)
-h Prints this help

Looks like there's a -f and -F option to use various files.
Admittedly, you might not be starting it up with /etc/init.d/pgpool2
each time now. But the basics are there.