[pgpool-general: 2955] Re: PGPool and Watchdog

[Guy Meler]

>From my observing, the benefits of watchdog is the configuration
synchronization between pgpool instances. That means that all pgpool
instances are sharing information about the state of each backend and it's
role (master/slave).


On Mon, Jun 23, 2014 at 9:33 AM, James Sewell <james.sewell at lisasoft.com>
wrote:

> Hello All,
>
> I have a load balancer in front of a pair of pgpool nodes (3.3.1), in
> front of a pair of PostgreSQL   nodes (9.3) which are configured as a
> streaming pair. I am running on RHEL.
>
> I am using another HA tool to manage the failover between the Postgres
> nodes, and the load is spread between the pgpool nodes with inactive nodes
> being taken out of the load balanced pool.
>
> Do I need watchdog in this case? I have seen reports that pgpool still
> synchronises useful information using this connection, but can't find what
> this information is?
>
> If I did use watchdog, which settings would I need in this limited case?
>
> Also is there a pcp command which I can use to tell pgpool that a new node
> is master, but not actually promote it (this would have happened already)?
> Does pcp_promote_node do this when no promotion script is provided?
>
> Thanks for the help.
>
> Cheers,
>
> James Sewell,
> Solutions Architect
> ______________________________________
>
>
>  Level 2, 50 Queen St, Melbourne VIC 3000
>
> *P *(+61) 3 8370 8000  *W* www.lisasoft.com  *F *(+61) 3 8370 8099
>
>
> ------------------------------
> The contents of this email are confidential and may be subject to legal or
> professional privilege and copyright. No representation is made that this
> email is free of viruses or other defects. If you have received this
> communication in error, you may not copy or distribute any part of it or
> otherwise disclose its contents to anyone. Please advise the sender of your
> incorrect receipt of this correspondence.
>
>
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20140623/e8069290/attachment.htm>