Re: pgpool

Scott Marlowe wrote:
> 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.

Thanks muchly, that should give me a good kick start.


--
Until later, Geoffrey

"I predict future happiness for America if they can prevent
the government from wasting the labors of the people under
the pretense of taking care of them."
- Thomas Jefferson