[pgpool-committers: 4965] pgpool: Add "last_status_change" column to "show pool_nodes" command.

Tatsuo Ishii ishii at postgresql.org
Tue Aug 7 21:43:30 JST 2018


Add "last_status_change" column to "show pool_nodes" command.

The new column indicates the time when "status" or "role" has been
changed. See [pgpool-hackers: 2822] for the reasoning to add the
column.

Probably "last_status_change" should be added to pcp_node_info command
and pgpool_adm functions as well but they are not included in this
commit.

Branches
--------
SCRAM_AUTH
master
query_cache

Details
-------
https://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=0312dc5a142edf5e24df611ad31e41f89204d860

Modified Files
--------------
doc.ja/src/sgml/ref/show_pool_nodes.sgml           | 29 +++++++++++----------
doc/src/sgml/ref/show_pool_nodes.sgml              | 23 ++++++++++-------
src/include/pcp/libpcp_ext.h                       |  4 ++-
src/include/pool.h                                 |  1 +
src/main/pgpool_main.c                             | 30 ++++++++++++++++++++++
src/protocol/pool_connection_pool.c                |  6 ++++-
.../tests/003.failover/create_expected.sql         | 11 ++++----
.../tests/003.failover/create_expected_node0.sql   | 11 ++++----
src/test/regression/tests/003.failover/test.sh     |  4 +--
src/utils/pool_process_reporting.c                 | 17 +++++++++++-
10 files changed, 99 insertions(+), 37 deletions(-)



More information about the pgpool-committers mailing list