<div dir="ltr">Not exactly.<div><br></div><div>Two Linux boxes, both with pgpool and postgresql. Pools use watchdog and "virtual IP" for HA, the two postgresql servers are the backend.</div><div><br></div><div>I don't think it is good for anything, but let's try:</div>
<div><br></div><div> /->pg-1(pool:5432)---+---+--pg:5433</div><div>Virt-IP --+ X</div><div> \->pg-2(pool:5432)---+---+--pg:5433</div><div><br></div><div>Is there really something strange? It looks quite straightforward for me.</div>
<div><br></div><div>Anyway, specifying localhost and other server didn't work, I now use "myhostname", "otherhostname" for the two backends, on both pool members. Seems to work, do the replication.</div>
<div>Still there's that if I use pcp, I get the backends in different order on both pool members. Still do not really understand, why pool members in a HA configuration doesn't share the backend configuration.</div>
<div><br></div><div>I have just discovered a weekness of our configuration (two identical servers replicating): If I have any problem other than a hardware issue, I will very probably have this on both.</div><div><br></div>
<div>Regards,</div><div><br></div><div>Attila</div></div><div class="gmail_extra"><br><br><div class="gmail_quote">2014-04-11 1:09 GMT+02:00 Tatsuo Ishii <span dir="ltr"><<a href="mailto:ishii@postgresql.org" target="_blank">ishii@postgresql.org</a>></span>:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="im HOEnZb">[Back to to mailing list]<br>
Please reply to the mailing list, rather than me...<br>
<br>
If my understanding is correct, this looks like a "cascade" and<br>
"circular" configuration.<br>
<br>
+--------------------+<br>
| |<br>
| v<br>
postgres-1--+->postgres-2--+->PostgreSQL<br>
^ |<br>
| |<br>
+--------------------------+<br>
<br>
What's the point of the configuration?<br>
<br>
</div><div class="HOEnZb"><div class="h5">Best regards,<br>
--<br>
Tatsuo Ishii<br>
SRA OSS, Inc. Japan<br>
English: <a href="http://www.sraoss.co.jp/index_en.php" target="_blank">http://www.sraoss.co.jp/index_en.php</a><br>
Japanese: <a href="http://www.sraoss.co.jp" target="_blank">http://www.sraoss.co.jp</a><br>
<br>
> It's very easy, the relevant part is here:<br>
><br>
> node postgres-2:<br>
> -----------------------<br>
> backend_hostname0 = 'localhost'<br>
> backend_port0 = 5433<br>
> backend_weight0 = 1<br>
> backend_data_directory0 = '/var/lib/postgresql/9.3'<br>
> backend_flag0 = 'ALLOW_TO_FAILOVER'<br>
><br>
><br>
> backend_hostname1 = 'postgres-1'<br>
> backend_port1 = 5433<br>
> backend_weight1 = 1<br>
> backend_data_directory1 = '/var/lib/postgresql/9.3'<br>
> backend_flag1 = 'ALLOW_TO_FAILOVER'<br>
><br>
> node postgres-1:<br>
> -----------------------<br>
> backend_hostname0 = 'localhost'<br>
> backend_port0 = 5433<br>
> backend_weight0 = 1<br>
> backend_data_directory0 = '/var/lib/postgresql/9.3'<br>
> backend_flag0 = 'ALLOW_TO_FAILOVER'<br>
><br>
><br>
> backend_hostname1 = 'postgres-2'<br>
> backend_port1 = 5433<br>
> backend_weight1 = 1<br>
> backend_data_directory1 = '/var/lib/postgresql/9.3'<br>
> backend_flag1 = 'ALLOW_TO_FAILOVER'<br>
><br>
><br>
><br>
> 2014-04-04 1:10 GMT+02:00 Tatsuo Ishii <<a href="mailto:ishii@postgresql.org">ishii@postgresql.org</a>>:<br>
><br>
>> I'm a little bit confused. Can you show your pgpool.conf?<br>
>><br>
>> Best regards,<br>
>> --<br>
>> Tatsuo Ishii<br>
>> SRA OSS, Inc. Japan<br>
>> English: <a href="http://www.sraoss.co.jp/index_en.php" target="_blank">http://www.sraoss.co.jp/index_en.php</a><br>
>> Japanese: <a href="http://www.sraoss.co.jp" target="_blank">http://www.sraoss.co.jp</a><br>
>><br>
>> > Hi!<br>
>> ><br>
>> > Just a simple question:<br>
>> ><br>
>> > Is the order of the nodes important for the pgpool cluster-members?<br>
>> > I guess the answer is no, since only one pool member will be active at<br>
>> any<br>
>> > time, the only important is to enumerate all the backends for all the<br>
>> pool<br>
>> > members...<br>
>> ><br>
>> > But still I would like to know.<br>
>> ><br>
>> > Currently I use localhost as backend0 for all the nodes, and enumerate<br>
>> all<br>
>> > other backends in some order starting from backend1.<br>
>> > The configs are generated from data tables (called pillars) by saltstack,<br>
>> > currently I do not specify any order.<br>
>> ><br>
>> > The only strange thing is, that running pcp_node_info gives different<br>
>> > result for the same node number on all members.<br>
>> ><br>
>> > Regards,<br>
>> > Attila<br>
>><br>
</div></div></blockquote></div><br></div>