PG10中《数据库XLOG, 流复制状态分析》这部分的几个SQL有改动

[jackgo73]

https://github.com/digoal/pgsql_admin_script/blob/5fbdcc8c71507c622dff4bc0976456b73e60a53b/generate_report.sh#L781-L799

这里用到的3个SQL在PG10中有改动

-- PG9
select pg_xlogfile_name(pg_current_xlog_location()) now_xlog, * from pg_stat_archiver;

-- PG10
select pg_walfile_name(pg_current_wal_lsn()) now_xlog, * from pg_stat_archiver;

--PG9
select pg_xlog_location_diff(pg_current_xlog_location(),flush_location), * from pg_stat_replication

--PG10
select pg_wal_lsn_diff(pg_current_wal_lsn(),flush_lsn), * from pg_stat_replication;

--PG9
select pg_xlog_location_diff(pg_current_xlog_location(),restart_lsn), * from pg_replication_slots;

--PG10
select pg_wal_lsn_diff(pg_current_wal_lsn(),restart_lsn), * from pg_replication_slots;