Re: pgpool

On Mon, Jun 21, 2010 at 2:42 PM, Geoffrey <lists@serioustechnology.com> wrote:
> Scott Marlowe wrote:
>>
>> On Mon, Jun 21, 2010 at 1:45 PM, Geoffrey <lists@serioustechnology.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.