[pgpool-general: 1751] Re: Question about watchdog

[ning chan]

if i have three different servers and each one of them running pgpool and
postgresql.
One of the server is Primary db, the other two connect to primary with
streaming replication.

If on primary I set the trusted_server to the other two nodes, and only one
of the server is not pingable to the primary, what would happen?



On Mon, May 13, 2013 at 11:34 PM, Yugo Nagata <nagata at sraoss.co.jp> wrote:

> Hi,
>
> On Mon, 13 May 2013 22:56:46 -0500
> ning chan <ninchan8328 at gmail.com> wrote:
>
> > Hi All,
> > There is a parameter "trusted_servers" under the Watchdog session to
> check
> > the upstream connection by pinging the server.
> >
> > I would like to know what happen if any of the listed server is not
> > pingable?
> > What kind of action will pgpool take?
> > Or what happen if none of the server are pingable?
>
> If any of the server is pingalbe, nothing occurs.
>
> If none of the server are pingable, watchdog changes the pgpool status to
> down.
> If the pgpool is active (VIP holder), any other pgpool becomes new active.
>
> >
> > Thanks~
> > Ning
>
>
> --
> Yugo Nagata <nagata at sraoss.co.jp>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20130515/fec58bbc/attachment.html>