diff options
author | cvs2svn <cvs2svn@FreeBSD.org> | 2002-08-10 04:35:28 +0000 |
---|---|---|
committer | cvs2svn <cvs2svn@FreeBSD.org> | 2002-08-10 04:35:28 +0000 |
commit | f124555536ce4b815ff160312c094545c36ec440 (patch) | |
tree | 702199d3b5e34c9ba151483313d8c26565451c75 /databases/postgresql81-server/files/502.pgsql | |
parent | Add pd-0.35.23 (diff) |
This commit was manufactured by cvs2svn to create tag 'RELEASE_4_6_2'.release/4.6.2
Diffstat (limited to 'databases/postgresql81-server/files/502.pgsql')
-rw-r--r-- | databases/postgresql81-server/files/502.pgsql | 88 |
1 files changed, 0 insertions, 88 deletions
diff --git a/databases/postgresql81-server/files/502.pgsql b/databases/postgresql81-server/files/502.pgsql deleted file mode 100644 index 32d473826f40..000000000000 --- a/databases/postgresql81-server/files/502.pgsql +++ /dev/null @@ -1,88 +0,0 @@ -#!/bin/sh -# -# $Id: 502.pgsql.in,v 1.17 2001/10/29 10:12:32 henrik Exp $ -# -# Maintenance shell script to vacuum and backup database -# Put this in /usr/local/etc/periodic/daily, and it will be run -# every night -# -# Written by Palle Girgensohn <girgen@partitur.se> -# -# In public domain, do what you like with it, -# and use it at your own risk... :) -# -############################ - -# arguments to pg_dump -PGDUMP_ARGS="-b -F c" - -# the directory where the backups will reside -# ${HOME} is pgsql's home directory -PGBACKUPDIR=${HOME}/backups - -# some data is amazingly more compressed with bzip2, esp. blobs, it seems -# if your're short on diskspace, give it a try and set USEBZIP=yes -USEBZIP=no - -############################ - -DIR=`dirname $0` -progname=`basename $0` -PRG=`cd $DIR; pwd `/$progname - -# Run as user pgsql -if [ `id -un` != pgsql ]; then - su -l pgsql -c ${PRG} - exit $? -fi - -if [ X${USEBZIP} = Xyes ]; then - BZIP=`which bzip2 || echo true` -else - BZIP=true -fi - -# PGBACKUPDIR must be writeable by user pgsql -# ~pgsql is just that under normal circumstances, -# but this might not be where you want the backups... -if [ ! -d ${PGBACKUPDIR} ] ; then - echo Creating ${PGBACKUPDIR} - mkdir ${PGBACKUPDIR} - chmod 700 ${PGBACKUPDIR} -fi - -echo -echo "PostgreSQL maintenance" - -# Protect the data -umask 077 -dbnames=`psql -q -t -A -d template1 -c "SELECT datname FROM pg_database WHERE datname != 'template0'"` -rc=$? -for db in ${dbnames}; do - echo -n " $db" - file=${PGBACKUPDIR}/pgdump_${db}_`date "+%Y%m%d"` - pg_dump ${PGDUMP_ARGS} -d $db -f ${file} - [ $? -gt 0 ] && rc=3 - ${BZIP} ${file} -done - -if [ $rc -gt 0 ]; then - echo - echo "Errors were reported during backup." -fi - -echo -echo "vacuuming..." -vacuumdb -a -z -q -if [ $? -gt 0 ] -then - echo - echo "Errors were reported vacuum." - rc=3 -fi - -# cleaning up old data -find ${PGBACKUPDIR} \( -name 'pgdump_*'.${GZIPEXT} -o -name 'pgdumpall_*'.${GZIPEXT} \) \ - -a -atime +7 -delete - -exit $rc |