[pgpool-hackers: 1878] Pgpool-II can send write queries to standby

[Yugo Nagata]

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>