[pgpool-hackers: 1878] Pgpool-II can send write queries to standby
Yugo Nagata
nagata at sraoss.co.jp
Tue Oct 25 17:19:40 JST 2016
Hi,
In some cases, Pgpool-II can lost the primary server whether the primary
is alive or not. Even in this case, Pgpool-II tries send write query
to backend, and when the primary is alive and this is same as master,
the query succeeds.
postgres=# show pool_nodes;
node_id | hostname | port | status | lb_weight | role | select_cnt
---------+----------+------+--------+-----------+---------+------------
0 | osspc20 | 5432 | 3 | 0.333333 | standby | 1
1 | osspc33 | 5432 | 2 | 0.333333 | standby | 0
2 | osspc34 | 5432 | 3 | 0.333333 | standby | 0
(3 rows)
postgres=# insert into hoge values(1);
INSERT 0 1
However, this would be odd for user because the the status that user
can see is standby. Pgpool-II should raise an error in such cases or
add other information as status?
--
Yugo Nagata <nagata at sraoss.co.jp>
More information about the pgpool-hackers
mailing list