[pgpool-committers: 5681] pgpool: Add "replication_state" and "replication_sync_state" columns to

[Tatsuo Ishii]

Add "replication_state" and "replication_sync_state" columns to "show pool_nodes" and friends.

This allows to show important information from pg_stat_replication,
which is available from PostgreSQL 9.1 (also without
replication_state_sync. it's available since 9.2).

For this purpose new "backend_application_name" parameter is added.
pg_stat_replication is called from pool_worker_process at the same
timing of replication delay checking.

Also modify following commands to add those new columns:

- pcp_node_info
- pgpool_adm's pcp_node_info function

Discussion: https://www.pgpool.net/pipermail/pgpool-hackers/2019-April/003315.html

Branch
------
master

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

Modified Files
--------------
doc.ja/src/sgml/connection-settings.sgml           | 19 ++++-
doc.ja/src/sgml/ref/pcp_node_info.sgml             | 28 ++++---
doc.ja/src/sgml/ref/pgpool_adm_pcp_node_info.sgml  | 25 +++++--
doc.ja/src/sgml/ref/show_pool_nodes.sgml           |  8 +-
doc/Makefile.in                                    | 24 ++++--
doc/src/sgml/connection-settings.sgml              | 24 ++++++
doc/src/sgml/ref/pcp_node_info.sgml                | 24 +++---
doc/src/sgml/ref/pgpool_adm_pcp_node_info.sgml     | 23 +++++-
doc/src/sgml/ref/show_pool_nodes.sgml              | 14 ++--
src/config/pool_config_variables.c                 | 39 ++++++++++
src/include/pcp/libpcp_ext.h                       |  8 +-
src/libs/pcp/pcp.c                                 | 14 ++++
src/pcp_con/pcp_worker.c                           |  4 +
src/sql/pgpool_adm/Makefile                        |  2 +-
src/sql/pgpool_adm/pgpool_adm--1.1--1.2.sql        | 11 +++
src/sql/pgpool_adm/pgpool_adm--1.2.sql             | 85 ++++++++++++++++++++++
src/sql/pgpool_adm/pgpool_adm.c                    | 20 +++--
src/sql/pgpool_adm/pgpool_adm.control              |  2 +-
src/streaming_replication/pool_worker_child.c      | 54 ++++++++++++++
.../tests/003.failover/create_expected.sql         | 12 +--
.../tests/003.failover/create_expected_node0.sql   | 12 +--
src/tools/pcp/pcp_frontend_client.c                | 52 ++++++++++++-
src/utils/pool_process_reporting.c                 | 37 +++++++++-
23 files changed, 471 insertions(+), 70 deletions(-)