[pgpool-general: 2953] PGPool and Watchdog

[James Sewell]

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20140623/1ec55189/attachment.html>