From 4f2338a51283958389e867f85750061646cd3971 Mon Sep 17 00:00:00 2001 From: Dan Goodliffe Date: Tue, 9 Apr 2019 18:45:40 +0100 Subject: Revised checkPostgreSQLrepl for v11 logical rep --- scripts/checkPostgreSQLrepl | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) (limited to 'scripts/checkPostgreSQLrepl') diff --git a/scripts/checkPostgreSQLrepl b/scripts/checkPostgreSQLrepl index 6558cf3..20b74fe 100755 --- a/scripts/checkPostgreSQLrepl +++ b/scripts/checkPostgreSQLrepl @@ -1,5 +1,5 @@ #!/bin/bash -CHECKSQL="SELECT ss.subscription_name, status, provider_node, provider_dsn FROM pglogical.subscription s, pglogical.show_subscription_status(s.sub_name) ss" -echo "$CHECKSQL" | psql -U postgres p2pvr -h firebrand -echo "$CHECKSQL" | psql -U postgres gentoobrowse -h defiant +CHECKSQL="SELECT application_name AS name, COALESCE(client_hostname, CAST(client_addr AS TEXT)) AS client, state, sync_state AS type, pg_wal_lsn_diff(sent_lsn, replay_lsn) AS lag FROM pg_stat_replication" +echo "$CHECKSQL" | psql -U postgres -h firebrand +echo "$CHECKSQL" | psql -U postgres -h defiant -- cgit v1.2.3