diff options
Diffstat (limited to 'databases/pgpool-II-30/files/pgpool_switch_xlog')
| -rw-r--r-- | databases/pgpool-II-30/files/pgpool_switch_xlog | 20 |
1 files changed, 0 insertions, 20 deletions
diff --git a/databases/pgpool-II-30/files/pgpool_switch_xlog b/databases/pgpool-II-30/files/pgpool_switch_xlog deleted file mode 100644 index 8ce8b8603a46..000000000000 --- a/databases/pgpool-II-30/files/pgpool_switch_xlog +++ /dev/null @@ -1,20 +0,0 @@ -#!/bin/sh -# -# $FreeBSD$ - -logger="logger -t pgpool -p local0.info" -psql=/usr/local/bin/psql - -/bin/sh <<EOF | ${logger} 2>&1 - -$psql -t -c 'SELECT datname FROM pg_database WHERE NOT datistemplate AND datallowconn' template1 | -while read i -do - if [ "$i" != "" ];then - $psql -c "SELECT setval(oid, nextval(oid)) FROM pg_class WHERE relkind = 'S'" $i - fi -done - -$psql -c 'select pg_switch_xlog()' template1 - -EOF |