No subject

Sat Nov 16 19:48:32 JST 2013

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

--047d7bd8fe94ebadc304fc7fc726
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">From my observing, the benefits of watchdog is the configu=
ration synchronization between pgpool instances. That means that all pgpool=
 instances are sharing information about the state of each backend and it&#=
39;s role (master/slave).</div>
<div class=3D"gmail_extra"><br><br><div class=3D"gmail_quote">On Mon, Jun 2=
3, 2014 at 9:33 AM, James Sewell <span dir=3D"ltr">&lt;<a href=3D"mailto:ja=
mes.sewell at lisasoft.com" target=3D"_blank">james.sewell at lisasoft.com</a>&gt=
;</span> wrote:<br>
<blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1p=
x #ccc solid;padding-left:1ex"><div dir=3D"ltr">Hello All,<div><br></div><d=
iv>I have a load balancer in front of a pair of pgpool nodes (3.3.1), in fr=
ont of a pair of PostgreSQL =C2=A0 nodes (9.3) which are configured as a st=
reaming pair. I am running on RHEL.</div>

<div><br></div><div>I am using another HA tool to manage the failover betwe=
en the Postgres nodes, and the load is spread between the pgpool nodes with=
 inactive nodes being taken out of the load balanced pool.</div><div><br>

</div><div>Do I need watchdog in this case? I have seen reports that pgpool=
 still synchronises useful information using this connection, but can&#39;t=
 find what this information is?</div><div><br></div><div>If I did use watch=
dog, which settings would I need in this limited case?</div>

<div><br></div><div>Also is there a pcp command which I can use to tell pgp=
ool 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?</div>

<div><br></div><div>Thanks for the help.</div><div><br></div><div>Cheers,</=
div><div><div><div style=3D"color:#b8276a;font:bold 14px Arial,Helvetica,sa=
ns-serif">
	<br>
	<span style=3D"color:#323b62">James Sewell,</span><br><span style=3D"color=
:#a9a9a9"><span style=3D"font:12px Arial,Helvetica,sans-serif">Solutions Ar=
chitect </span></span><br>
	<span style=3D"color:#a9a9a9">______________________________________</span=
><br>
	=C2=A0</div>
<img alt=3D"" src=3D"http://www.lisasoft.com/sites/lisasoft/files/u1/logo1.=
jpg" style=3D"margin:0px;width:153px;min-height:50px"><br>
<div style=3D"font:normal 12px/20px Arial,Helvetica,sans-serif;color:#40404=
0;margin:0">
	<span style=3D"color:#a9a9a9">Level 2, 50 Queen St, Melbourne VIC 3000</sp=
an><br>
	<br>
	<strong>P=C2=A0</strong><span style=3D"color:#a9a9a9"><span style=3D"font-=
family:Arial,Verdana,sans-serif"><a href=3D"tel:%28%2B61%29%203%208370%2080=
00" value=3D"+61383708000" target=3D"_blank">(+61) 3 8370 8000</a></span></=
span><span style=3D"color:rgb(169,169,169)">=C2=A0</span><strong> </strong>=
<span style=3D"color:rgb(50,59,98)"><span style=3D"width:15px;display:inlin=
e-block"><strong>W</strong></span></span> <a style=3D"color:rgb(64,64,64);m=
argin:2px 0px;text-decoration:none"><span style=3D"color:#a9a9a9">www.lisas=
oft.com</span></a>=C2=A0 <span style=3D"color:rgb(50,59,98)"><span style=3D=
"width:15px;display:inline-block"><strong>F=C2=A0</strong></span></span><sp=
an style=3D"color:#a9a9a9"><span style=3D"font-family:Arial,Verdana,sans-se=
rif"><a href=3D"tel:%28%2B61%29%203%208370%208099" value=3D"+61383708099" t=
arget=3D"_blank">(+61) 3 8370 8099</a></span></span></div>

<div style=3D"padding-top:8px">
	=C2=A0</div></div>
</div></div>

<br>
<p></p><div style=3D"color:rgb(34,34,34);font-family:arial,sans-serif;font-=
size:14.545454025268555px;background-color:rgb(255,255,255)"><hr><font size=
=3D"1" color=3D"Gray" face=3D"Arial">The contents of this email are confide=
ntial and may be subject to legal or professional privilege and copyright. =
No representation is made that this email is free of viruses or other defec=
ts. If you have received this communication in error, you may not copy or d=
istribute any part of it or otherwise disclose its contents to anyone. Plea=
se advise the sender of your incorrect receipt of this correspondence.</fon=
t></div>
<p></p><br>_______________________________________________<br>
pgpool-general mailing list<br>
<a href=3D"mailto:pgpool-general at pgpool.net">pgpool-general at pgpool.net</a><=
br>
<a href=3D"http://www.pgpool.net/mailman/listinfo/pgpool-general" target=3D=
"_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br>
<br></blockquote></div><br></div>

--047d7bd8fe94ebadc304fc7fc726--