[pgpool-general: 3541] Re: Add new node weirdness (master slave)

Mark Kirkwood mark.kirkwood at catalyst.net.nz
Wed Mar 18 10:55:35 JST 2015


On 18/03/15 14:42, Mark Kirkwood wrote:
> On 18/03/15 13:00, Tatsuo Ishii wrote:
>>> As I understand it I should do:
>>>
>>> - install postgres on the db3, stop the postgres service
>>> - edit pgpool.conf to add the db3
>>> - reload pgpool2 service
>>> - recover db3
>>
>> Correct.
>>
>>> I found that in fact I had to:
>>> - reload db3 - observe that db3 *not* detected.
>>
>> Works for me. What did you add to pgpool.conf exactly?
>>
>
> I've attached my pgpool.conf
>

Ahh - I understand the problem now:

$ sudo service pgpool2 reload

does nothing, but

$ sudo pgpool reload

actually sends a sighup and things work as advertised. So we have a bit 
of confusion(!) resulting from the service setup not acting as it should 
(Ubuntu/Debian bug)?

Cheers

Mark



More information about the pgpool-general mailing list