[pgpool-general: 6007] PgPool - Primary detection

[Mathias Buresch]

Hi,

how does PgPool Check the primary node of Postgresql?

At the moment both Postgresql server are Primary/Master..
But:

Every 2.0s: sudo -u postgres psql -h 213.221.108.90 -p 5433 -c 'show pool_nodes;’

node_id |    hostname    | port | status | lb_weight |  role   | select_cnt | load_balance_node | replication_delay
---------+----------------+------+--------+-----------+---------+------------+-------------------+-------------------
0             | 10.10.10.88 | 5432 | up     | 0.500000  | primary | 0          | false             | 0
1             | 10.10.10.89 | 5432 | up     | 0.500000  | standby | 0          | true              | 0

So how can that be?

I am running CentOS and PgPool 3.7.2-2.

PS: Does anyone have a STONITH vmware fencing solution? 😉


Mit herzlichen Grüßen

Mathias Buresch
Systems Engineer
--
mathias.buresch at de.clara.net
Tel: +49 (69) 40 80 18 - 265
Fax: +49 (69) 40 80 18 - 129

Claranet GmbH
Hanauer Landstraße 196
60314 Frankfurt

Geschäftsführung Olaf Fischer
Hrb 50381 AG Frankfurt am Main
Vat-ID de 812918694

http://www.claranet.de

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20180328/feacea21/attachment.html>