diff options
| author | Dan Goodliffe <dan@randomdan.homeip.net> | 2014-12-11 14:30:43 +0000 |
|---|---|---|
| committer | Dan Goodliffe <dan@randomdan.homeip.net> | 2014-12-11 14:30:43 +0000 |
| commit | c229e72929f80a64c30810e279d8904b8b33456e (patch) | |
| tree | 71d16215bfb8984ee5e2da893041912e3ebdd711 /scripts/checkPostgreSQLrepl | |
| parent | Move dhcp into its own folder (diff) | |
| download | config-c229e72929f80a64c30810e279d8904b8b33456e.tar.bz2 config-c229e72929f80a64c30810e279d8904b8b33456e.tar.xz config-c229e72929f80a64c30810e279d8904b8b33456e.zip | |
Big refresh
Diffstat (limited to 'scripts/checkPostgreSQLrepl')
| -rwxr-xr-x | scripts/checkPostgreSQLrepl | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/scripts/checkPostgreSQLrepl b/scripts/checkPostgreSQLrepl new file mode 100755 index 0000000..19e2615 --- /dev/null +++ b/scripts/checkPostgreSQLrepl @@ -0,0 +1,2 @@ +echo "select st_received as n, date_trunc('second', st_last_received_event_ts) as effective_db_time, date_trunc('second', st_last_received_ts) as last_heard_from, date_trunc('second', st_lag_time) as lagged_by from _gentoo.sl_status order by st_received;" | psql -Upostgres gentoo -hfirebrand +echo "select st_received as n, date_trunc('second', st_last_received_event_ts) as effective_db_time, date_trunc('second', st_last_received_ts) as last_heard_from, date_trunc('second', st_lag_time) as lagged_by from _gentoo.sl_status order by st_received;" | psql -Upostgres gentoo -hdefiant |