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

[Gurjeet Singh]

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.

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/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-hackers/attachments/20120912/b1fe823e/attachment.html>