diff options
author | Jun Kuriyama <kuriyama@FreeBSD.org> | 2010-02-22 11:20:13 +0000 |
---|---|---|
committer | Jun Kuriyama <kuriyama@FreeBSD.org> | 2010-02-22 11:20:13 +0000 |
commit | b036602676f95b559f0238af38f3a85c5e047365 (patch) | |
tree | d544b7d8463893bbc0e04c5f419c5733b4a219ba /databases/pgpool-II/files/pgpool_copy_backup | |
parent | a3531af2232ee6c6d86cdb15ad64ca61b1a11b5c (diff) | |
download | ports-b036602676f95b559f0238af38f3a85c5e047365.tar.gz ports-b036602676f95b559f0238af38f3a85c5e047365.zip |
Notes
Diffstat (limited to 'databases/pgpool-II/files/pgpool_copy_backup')
-rw-r--r-- | databases/pgpool-II/files/pgpool_copy_backup | 11 |
1 files changed, 7 insertions, 4 deletions
diff --git a/databases/pgpool-II/files/pgpool_copy_backup b/databases/pgpool-II/files/pgpool_copy_backup index 31d0d4651921..aa6a5226d53a 100644 --- a/databases/pgpool-II/files/pgpool_copy_backup +++ b/databases/pgpool-II/files/pgpool_copy_backup @@ -1,6 +1,10 @@ #!/bin/sh # # $FreeBSD$ +# +# In postgresql.conf: +# archive_command = 'test -f /proj/pgsql/data/archive_log/%f || cp %p /proj/pgsql/data/archive_log/%f' +# SRC=pgsql@$(hostname) SRCDIR=$1 @@ -10,16 +14,15 @@ ARCLOG=$1/archive_log logger="logger -t pgpool -p local0.info" rsync="/usr/local/bin/rsync -av --delete --checksum" -excl="--exclude=pg_log --exclude=archive_log --exclude=postmaster.pid" -psql=/usr/local/bin/psql +excl="--exclude=pg_log --exclude=postmaster.pid" +psql="/usr/local/bin/psql" /bin/sh <<EOF | ${logger} 2>&1 $psql -c "select pg_start_backup('pgpool-recovery')" template1 ssh $DEST " -/usr/local/etc/rc.d/postgresql stop; -rm -rf $DESTDIR/pg_xlog; +/usr/local/bin/pg_ctl -D $DESTDIR -s -m fast stop; rm -f $DESTDIR/backup_label" echo "restore_command = 'scp $SRC:$ARCLOG/%f %p'" > $SRCDIR/recovery.conf |