<div dir="ltr">Dear Guys,<div><br></div><div>How on earth it is possible, that the pool members reports different backend status? It will cause problems very soon I guess.</div><div><br></div><div><div> Node: 1</div><div>
Host: 10.100.1.11</div><div> Port: 5433</div><div> Weight: 0.500000</div><div> Status: Up, in pool (1)</div><div> WD status: Standby (2)</div><div><br></div><div> Node: 2</div><div> Host: 10.100.1.10</div>
<div> Port: 5433</div><div> Weight: 0.500000</div><div> Status: Up, in pool (1)</div></div><div><br></div><div>---</div><div><br></div><div><div> Node: 1</div><div> Host: 10.100.1.11</div><div> Port: 5433</div>
<div> Weight: 0.500000</div><div> Status: Up, detached from pool (3)</div><div> WD status: Standby (2)</div><div><br></div><div> Node: 2</div><div> Host: 10.100.1.10</div><div> Port: 5433</div><div> Weight: 0.500000</div>
<div> Status: Up, in pool (1)</div><div> WD status: Standby (2)</div></div><div><br></div><div>---</div><div><br></div><div><div> Node: 1</div><div> Host: 10.100.1.11</div><div> Port: 5433</div><div> Weight: 0.500000</div>
<div> Status: Up, in pool (1)</div><div> WD status: Standby (2)</div><div><br></div><div> Node: 2</div><div> Host: 10.100.1.10</div><div> Port: 5433</div><div> Weight: 0.500000</div><div> Status: Up, in pool (1)</div>
<div> WD status: Active (3)</div></div><div><br></div><div>---</div><div><br></div><div><div> Node: 1</div><div> Host: 10.100.1.11</div><div> Port: 5433</div><div> Weight: 0.500000</div><div> Status: Up, in pool (1)</div>
<div> WD status: Standby (2)</div><div><br></div><div> Node: 2</div><div> Host: 10.100.1.10</div><div> Port: 5433</div><div> Weight: 0.500000</div><div> Status: Up, in pool (1)</div><div> WD status: Standby (2)</div>
</div><div><br></div><div>---</div><div><br></div><div><div> Node: 1</div><div> Host: 10.100.1.11</div><div> Port: 5433</div><div> Weight: 0.500000</div><div> Status: Up, detached from pool (3)</div><div> WD status: Standby (2)</div>
<div><br></div><div> Node: 2</div><div> Host: 10.100.1.10</div><div> Port: 5433</div><div> Weight: 0.500000</div><div> Status: Up, in pool (1)</div><div> WD status: Active (3)</div></div><div><br></div>
<div>
I have got five pool members, two of them are the backends themselves.</div><div><br></div><div>Every pool member has the other 4 as other_pgpool, and heartbeat_destination, and the same two backend servers, here is the relevant part of the config for all pool members:</div>
<div><br></div><div><div><br></div><div>nor-openfire-1:</div><div> backend_hostname1 = '10.100.1.11'</div><div> backend_port1 = 5433</div><div> backend_weight1 = 1</div><div> backend_data_directory1 = '/var/lib/postgresql/9.3'</div>
<div> backend_flag1 = 'ALLOW_TO_FAILOVER'</div><div> backend_hostname2 = '10.100.1.10'</div><div> backend_port2 = 5433</div><div> backend_weight2 = 1</div><div> backend_data_directory2 = '/var/lib/postgresql/9.3'</div>
<div> backend_flag2 = 'ALLOW_TO_FAILOVER'</div><div> fail_over_on_backend_error = on</div><div> heartbeat_destination0 = 'nor-postgres-2'</div><div> heartbeat_destination_port0 = 9694</div><div>
other_pgpool_hostname0 = 'nor-postgres-2'</div><div> other_pgpool_port0 = 5432</div><div> heartbeat_destination1 = 'nor-jboss-2'</div><div> heartbeat_destination_port1 = 9694</div><div> other_pgpool_hostname1 = 'nor-jboss-2'</div>
<div> other_pgpool_port1 = 5432</div><div> heartbeat_destination2 = 'nor-postgres-1'</div><div> heartbeat_destination_port2 = 9694</div><div> other_pgpool_hostname2 = 'nor-postgres-1'</div><div>
other_pgpool_port2 = 5432</div><div> heartbeat_destination3 = 'nor-jboss-1'</div><div> heartbeat_destination_port3 = 9694</div><div> other_pgpool_hostname3 = 'nor-jboss-1'</div><div> other_pgpool_port3 = 5432</div>
<div>nor-postgres-1:</div><div> backend_hostname1 = '10.100.1.11'</div><div> backend_port1 = 5433</div><div> backend_weight1 = 1</div><div> backend_data_directory1 = '/var/lib/postgresql/9.3'</div>
<div> backend_flag1 = 'ALLOW_TO_FAILOVER'</div><div> backend_hostname2 = '10.100.1.10'</div><div> backend_port2 = 5433</div><div> backend_weight2 = 1</div><div> backend_data_directory2 = '/var/lib/postgresql/9.3'</div>
<div> backend_flag2 = 'ALLOW_TO_FAILOVER'</div><div> fail_over_on_backend_error = on</div><div> heartbeat_destination0 = 'nor-postgres-2'</div><div> heartbeat_destination_port0 = 9694</div><div>
other_pgpool_hostname0 = 'nor-postgres-2'</div><div> other_pgpool_port0 = 5432</div><div> heartbeat_destination1 = 'nor-jboss-2'</div><div> heartbeat_destination_port1 = 9694</div><div> other_pgpool_hostname1 = 'nor-jboss-2'</div>
<div> other_pgpool_port1 = 5432</div><div> heartbeat_destination2 = 'nor-openfire-1'</div><div> heartbeat_destination_port2 = 9694</div><div> other_pgpool_hostname2 = 'nor-openfire-1'</div><div>
other_pgpool_port2 = 5432</div><div> heartbeat_destination3 = 'nor-jboss-1'</div><div> heartbeat_destination_port3 = 9694</div><div> other_pgpool_hostname3 = 'nor-jboss-1'</div><div> other_pgpool_port3 = 5432</div>
<div>nor-postgres-2:</div><div> backend_hostname1 = '10.100.1.11'</div><div> backend_port1 = 5433</div><div> backend_weight1 = 1</div><div> backend_data_directory1 = '/var/lib/postgresql/9.3'</div>
<div> backend_flag1 = 'ALLOW_TO_FAILOVER'</div><div> backend_hostname2 = '10.100.1.10'</div><div> backend_port2 = 5433</div><div> backend_weight2 = 1</div><div> backend_data_directory2 = '/var/lib/postgresql/9.3'</div>
<div> backend_flag2 = 'ALLOW_TO_FAILOVER'</div><div> fail_over_on_backend_error = on</div><div> heartbeat_destination0 = 'nor-jboss-2'</div><div> heartbeat_destination_port0 = 9694</div><div> other_pgpool_hostname0 = 'nor-jboss-2'</div>
<div> other_pgpool_port0 = 5432</div><div> heartbeat_destination1 = 'nor-openfire-1'</div><div> heartbeat_destination_port1 = 9694</div><div> other_pgpool_hostname1 = 'nor-openfire-1'</div><div>
other_pgpool_port1 = 5432</div><div> heartbeat_destination2 = 'nor-postgres-1'</div><div> heartbeat_destination_port2 = 9694</div><div> other_pgpool_hostname2 = 'nor-postgres-1'</div><div> other_pgpool_port2 = 5432</div>
<div> heartbeat_destination3 = 'nor-jboss-1'</div><div> heartbeat_destination_port3 = 9694</div><div> other_pgpool_hostname3 = 'nor-jboss-1'</div><div> other_pgpool_port3 = 5432</div><div>nor-jboss-1:</div>
<div> backend_hostname1 = '10.100.1.11'</div><div> backend_port1 = 5433</div><div> backend_weight1 = 1</div><div> backend_data_directory1 = '/var/lib/postgresql/9.3'</div><div> backend_flag1 = 'ALLOW_TO_FAILOVER'</div>
<div> backend_hostname2 = '10.100.1.10'</div><div> backend_port2 = 5433</div><div> backend_weight2 = 1</div><div> backend_data_directory2 = '/var/lib/postgresql/9.3'</div><div> backend_flag2 = 'ALLOW_TO_FAILOVER'</div>
<div> fail_over_on_backend_error = on</div><div> heartbeat_destination0 = 'nor-postgres-2'</div><div> heartbeat_destination_port0 = 9694</div><div> other_pgpool_hostname0 = 'nor-postgres-2'</div>
<div> other_pgpool_port0 = 5432</div><div> heartbeat_destination1 = 'nor-jboss-2'</div><div> heartbeat_destination_port1 = 9694</div><div> other_pgpool_hostname1 = 'nor-jboss-2'</div><div> other_pgpool_port1 = 5432</div>
<div> heartbeat_destination2 = 'nor-openfire-1'</div><div> heartbeat_destination_port2 = 9694</div><div> other_pgpool_hostname2 = 'nor-openfire-1'</div><div> other_pgpool_port2 = 5432</div><div>
heartbeat_destination3 = 'nor-postgres-1'</div><div> heartbeat_destination_port3 = 9694</div><div> other_pgpool_hostname3 = 'nor-postgres-1'</div><div> other_pgpool_port3 = 5432</div><div>nor-jboss-2:</div>
<div> backend_hostname1 = '10.100.1.11'</div><div> backend_port1 = 5433</div><div> backend_weight1 = 1</div><div> backend_data_directory1 = '/var/lib/postgresql/9.3'</div><div> backend_flag1 = 'ALLOW_TO_FAILOVER'</div>
<div> backend_hostname2 = '10.100.1.10'</div><div> backend_port2 = 5433</div><div> backend_weight2 = 1</div><div> backend_data_directory2 = '/var/lib/postgresql/9.3'</div><div> backend_flag2 = 'ALLOW_TO_FAILOVER'</div>
<div> fail_over_on_backend_error = on</div><div> heartbeat_destination0 = 'nor-postgres-2'</div><div> heartbeat_destination_port0 = 9694</div><div> other_pgpool_hostname0 = 'nor-postgres-2'</div>
<div> other_pgpool_port0 = 5432</div><div> heartbeat_destination1 = 'nor-openfire-1'</div><div> heartbeat_destination_port1 = 9694</div><div> other_pgpool_hostname1 = 'nor-openfire-1'</div><div>
other_pgpool_port1 = 5432</div><div> heartbeat_destination2 = 'nor-postgres-1'</div><div> heartbeat_destination_port2 = 9694</div><div> other_pgpool_hostname2 = 'nor-postgres-1'</div><div> other_pgpool_port2 = 5432</div>
<div> heartbeat_destination3 = 'nor-jboss-1'</div><div> heartbeat_destination_port3 = 9694</div><div> other_pgpool_hostname3 = 'nor-jboss-1'</div><div> other_pgpool_port3 = 5432</div></div><div>
<br></div><div>Other question:</div><div><br></div><div>Our servers are connected via two networks. Is it possible to specify a pool member with both IP interfaces?</div><div><br></div><div>---------------------------------------------------------------------------------------- Network #1</div>
<div> | | | | |</div><div> S1 S2 S3 S4 S5</div><div> | | | | |</div>
<div>---------------------------------------------------------------------------------------- Network #2</div><div><br></div><div>none of the networks are connected with failover connections, both use different IP subnets.</div>
<div><br></div><div>Regards,</div><div><br></div><div>Attila</div><div><br></div></div>