Projet

Général

Profil

Révision 17f78427

ID17f784270ae966ee9a13e9f5104a5b8f925b639e
Parent ef851f0c
Enfant d4320aea, 5b2396a9

Ajouté par Lars Kruse il y a plus de 7 ans

Whitespace cleanup

  • remove trailing whitespace
  • remove empty lines at the end of files

Voir les différences:

plugins/postgresql/slony_lag_events_
14 14
# st_last_received_event_ts: the timestamp on the sl_event in that pair
15 15
# st_lag_num_events: difference between st_last_event and st_last_received
16 16
# st_lag_time: difference between st_last_event_ts and st_last_received_ts
17
# 
17
#
18 18
#
19 19
# Configuration variables:
20 20
#
......
54 54
    echo "graph_title Slony lag events for ${PGDATABASE}"
55 55
    echo 'graph_vlabel event'
56 56

  
57
    psql -h ${PGHOST} -d ${PGDATABASE} -U ${PGUSER} -tc "SELECT no_id,regexp_replace(pa_conninfo, '.*host=(.*?) .*$', '\\1') FROM ${PGSCHEMA}.sl_node JOIN ${PGSCHEMA}.sl_path ON (pa_server=no_id) WHERE pa_client=${PGSCHEMA}.getlocalnodeid('${PGSCHEMA}'::name);" | while read node_id sep host 
57
    psql -h ${PGHOST} -d ${PGDATABASE} -U ${PGUSER} -tc "SELECT no_id,regexp_replace(pa_conninfo, '.*host=(.*?) .*$', '\\1') FROM ${PGSCHEMA}.sl_node JOIN ${PGSCHEMA}.sl_path ON (pa_server=no_id) WHERE pa_client=${PGSCHEMA}.getlocalnodeid('${PGSCHEMA}'::name);" | while read node_id sep host
58 58
    do
59 59
        test -z "${node_id}" && continue
60 60
        echo "${node_id}.label ${host}"
......
68 68
fi
69 69

  
70 70
psql -h ${PGHOST} -d ${PGDATABASE} -U ${PGUSER} -tc "SELECT st_received, st_lag_num_events FROM ${PGSCHEMA}.sl_status ORDER BY 1;" | while read node_id sep event
71
do  
71
do
72 72
    test -z "${node_id}" && continue
73 73
    echo "${node_id}.value ${event}"
74 74
done

Formats disponibles : Unified diff