[pgpool-general: 1755] Re: Question about watchdog
nagata at sraoss.co.jp
Thu May 16 13:38:41 JST 2013
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
> 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?
Nothing would happen because one of the serve is pingable to the primary.
> 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>
More information about the pgpool-general