[pgpool-general: 2119] Re: Suggestion about two datacenters connected through WAN

Mistina Michal Michal.Mistina at virte.sk
Wed Sep 11 17:59:32 JST 2013

>> Hi Tatsuo.
>>> One thing you might want to use for this is, "trusted_servers". 
>>> Usually
>> you register router IPs you trust (pgpool should be able to reach the
>> router) for this. In the split brain case, if pgpool in TC1 or TC2 
>> finds that it cannot reach the IP anymore, it sucides to avoid going 
>> the split brain.
>> I will definetely try trusted_servers option.

Is it the requirement to have a watchdog enabled for trusted_servers option
to work?

>> It's working now. I tested easy fail-over to the secondary technical 
>> center (TC2). However I have found out I need to set 
>> health_check_period. If I leave it disabled (0) the pgpool does not 
>> know the PostgreSQL master is down. Is this correct behaviour? I 
>> couldn't find it in the manual pages. I thought only sr_check_period 
>> should be enabled for successful failure detection.

>It's documented in the doc.

>  health_check_period
>    This parameter specifies the interval between the health checks in
>    seconds. Default is 0, which means health check is disabled.

>> I'm using pgpool-II 3.3.0.
>> Best regards,
>> Michal Mistina

Best regards,
Michal Mistina

-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 3076 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20130911/e8d286eb/attachment.p7s>

More information about the pgpool-general mailing list