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

[Yugo Nagata]

On Wed, 15 May 2013 11:04:45 -0500
ning chan <ninchan8328 at gmail.com> wrote:

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

I can't reproduce this.
In your situation, are the servers pingable to each other by manual ping command?

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


-- 
Yugo Nagata <nagata at sraoss.co.jp>