3 # Written by Peter Palfrader
4 # Based on code by Tollef Fog Heen <tfheen@err.no> based on code by Peter Palfrader
6 # Restart all postgresql clusters when they do not have connections to them.
12 # returns true (0) if there are connections to that port.
14 local port="$1"; shift
15 local con="$(ss -H -nt "sport = :$port" | wc -l)"
16 if [ "$con" -ge 1 ]; then
24 local version="$1"; shift
25 local name="$1"; shift
27 local fn="/run/postgresql/${version}-${name}.pid"
28 if [ -e "$fn" ] ; then
31 echo "No pidfile at $fn" >&2
37 local version="$1"; shift
38 local name="$1"; shift
39 local port="$1"; shift
41 pid="$(get_pidfile_value "$version" "$name")"
42 while chk_net "$port" && [ "$pid" = "$(get_pidfile_value "$version" "$name")" ]; do
45 systemctl restart "postgresql@${version}-${name}.service"
48 pg_lsclusters -h | while read version name port status; do
49 echo "$status" | grep -q --word-regexp online || continue
50 handle_cluster $version $name $port &