<div dir="ltr">So far I haven't heard of any damaging or detrimental effects of -D option. The only effect and overhead that I can verify is that with -D option pgpool will connect to every backend_hostname to verify whether the database backend is reachable. This may cause some slowdown in initial pgpool startup, but the upside is that the backend_status value reflects the true status of a backend.<br>
<br>I guess I'll enable the -D option, possibly with the ability to disable it easily.<br><br>Best regards,<br><br><div class="gmail_quote">On Tue, Sep 11, 2012 at 8:59 PM, Tatsuo Ishii <span dir="ltr"><<a href="mailto:ishii@postgresql.org" target="_blank">ishii@postgresql.org</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Sounds like a good point.<br>
--<br>
Tatsuo Ishii<br>
SRA OSS, Inc. Japan<br>
English: <a href="http://www.sraoss.co.jp/index_en.php" target="_blank">http://www.sraoss.co.jp/index_en.php</a><br>
Japanese: <a href="http://www.sraoss.co.jp" target="_blank">http://www.sraoss.co.jp</a><br>
<div class="im HOEnZb"><br>
> The thing is, it's really easy to add -D via /etc/sysconfig/pgpool<br>
> using $OPTS, but if it's enabled by default it's more work to remove.<br>
> It's also probably not a good idea to change the default behavior, as<br>
> people are likely to rely on it staying the same.<br>
><br>
><br>
> alex<br>
><br>
><br>
> On 9/11/12 5:03 PM, Gurjeet Singh wrote:<br>
>> Any thoughts on this?<br>
>><br>
>> On Thu, Sep 6, 2012 at 9:55 AM, Gurjeet Singh <<a href="mailto:singh.gurjeet@gmail.com">singh.gurjeet@gmail.com</a><br>
</div><div class="HOEnZb"><div class="h5">>> <mailto:<a href="mailto:singh.gurjeet@gmail.com">singh.gurjeet@gmail.com</a>>> wrote:<br>
>><br>
>> Hi All,<br>
>><br>
>> I am considering adding the -D switch by default to the<br>
>> pgpool's initi script, so that pgpool ignores the last known state<br>
>> of a replica when pgpool was shutdown. I have seen situations<br>
>> where a replica goes down, and pgpool sets its state to 3<br>
>> (CON_DOWN), and even if replica is brought back online, and pgpool<br>
>> restarted (without -D switch), pgpool does not recognize the<br>
>> replica as usable.<br>
>><br>
>> Adding -D switch to pgpool startup script solves the problem<br>
>> for me. SO I am wondering if it is a bad idea in some cases to use<br>
>> -D switch by default.<br>
>><br>
>> Best regards,<br>
>> -- Gurjeet Singh<br>
>><br>
>> <a href="http://gurjeet.singh.im/" target="_blank">http://gurjeet.singh.im/</a><br>
>><br>
>><br>
>><br>
>><br>
>> --<br>
>> Gurjeet Singh<br>
>><br>
>> <a href="http://gurjeet.singh.im/" target="_blank">http://gurjeet.singh.im/</a><br>
>><br>
>><br>
>><br>
>> _______________________________________________<br>
>> pgpool-hackers mailing list<br>
>> <a href="mailto:pgpool-hackers@pgpool.net">pgpool-hackers@pgpool.net</a><br>
>> <a href="http://www.pgpool.net/mailman/listinfo/pgpool-hackers" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-hackers</a><br>
><br>
</div></div></blockquote></div><br><br clear="all"><br>-- <br><div dir="ltr">Gurjeet Singh<br><br><a href="http://gurjeet.singh.im/" target="_blank">http://gurjeet.singh.im/</a><br></div><br>
</div>