[pgpool-hackers: 127] Re: Enabling -D switch of pgpool by default

[Tatsuo Ishii]

> 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.

Really? At least Alex and I are not sure if it's a really good idea,
while no one is with your idea. Also I would like to hear from Devrim
since he is the mainter of init scripts.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

> I guess I'll enable the -D option, possibly with the ability to disable it
> easily.
>
> Best regards,
> 
> On Tue, Sep 11, 2012 at 8:59 PM, Tatsuo Ishii <ishii at postgresql.org> wrote:
> 
>> Sounds like a good point.
>> --
>> Tatsuo Ishii
>> SRA OSS, Inc. Japan
>> English: http://www.sraoss.co.jp/index_en.php
>> Japanese: http://www.sraoss.co.jp
>>
>> > The thing is, it's really easy to add -D via /etc/sysconfig/pgpool
>> > using $OPTS, but if it's enabled by default it's more work to remove.
>> > It's also probably not a good idea to change the default behavior, as
>> > people are likely to rely on it staying the same.
>> >
>> >
>> >   alex
>> >
>> >
>> > On 9/11/12 5:03 PM, Gurjeet Singh wrote:
>> >> Any thoughts on this?
>> >>
>> >> On Thu, Sep 6, 2012 at 9:55 AM, Gurjeet Singh <singh.gurjeet at gmail.com
>> >> <mailto:singh.gurjeet at gmail.com>> wrote:
>> >>
>> >>     Hi All,
>> >>
>> >>         I am considering adding the -D switch by default to the
>> >>     pgpool's initi script, so that pgpool ignores the last known state
>> >>     of a replica when pgpool was shutdown. I have seen situations
>> >>     where a replica goes down, and pgpool sets its state to 3
>> >>     (CON_DOWN), and even if replica is brought back online, and pgpool
>> >>     restarted (without -D switch), pgpool does not recognize the
>> >>     replica as usable.
>> >>
>> >>         Adding -D switch to pgpool startup script solves the problem
>> >>     for me. SO I am wondering if it is a bad idea in some cases to use
>> >>     -D switch by default.
>> >>
>> >>     Best regards,
>> >>     --     Gurjeet Singh
>> >>
>> >>     http://gurjeet.singh.im/
>> >>
>> >>
>> >>
>> >>
>> >> --
>> >> Gurjeet Singh
>> >>
>> >> http://gurjeet.singh.im/
>> >>
>> >>
>> >>
>> >> _______________________________________________
>> >> pgpool-hackers mailing list
>> >> pgpool-hackers at pgpool.net
>> >> http://www.pgpool.net/mailman/listinfo/pgpool-hackers
>> >
>>
> 
> 
> 
> -- 
> Gurjeet Singh
> 
> http://gurjeet.singh.im/