Re: pgpool

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

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