From owner-freebsd-ports-bugs@FreeBSD.ORG Tue Dec 13 12:20:09 2011 Return-Path: Delivered-To: freebsd-ports-bugs@hub.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id E7775106564A for ; Tue, 13 Dec 2011 12:20:09 +0000 (UTC) (envelope-from gnats@FreeBSD.org) Received: from freefall.freebsd.org (freefall.freebsd.org [IPv6:2001:4f8:fff6::28]) by mx1.freebsd.org (Postfix) with ESMTP id B6DA98FC16 for ; Tue, 13 Dec 2011 12:20:09 +0000 (UTC) Received: from freefall.freebsd.org (localhost [127.0.0.1]) by freefall.freebsd.org (8.14.5/8.14.5) with ESMTP id pBDCK9n3070707 for ; Tue, 13 Dec 2011 12:20:09 GMT (envelope-from gnats@freefall.freebsd.org) Received: (from gnats@localhost) by freefall.freebsd.org (8.14.5/8.14.5/Submit) id pBDCK9FI070706; Tue, 13 Dec 2011 12:20:09 GMT (envelope-from gnats) Resent-Date: Tue, 13 Dec 2011 12:20:09 GMT Resent-Message-Id: <201112131220.pBDCK9FI070706@freefall.freebsd.org> Resent-From: FreeBSD-gnats-submit@FreeBSD.org (GNATS Filer) Resent-To: freebsd-ports-bugs@FreeBSD.org Resent-Reply-To: FreeBSD-gnats-submit@FreeBSD.org, Frank Wall Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 18CBF1065670 for ; Tue, 13 Dec 2011 12:12:57 +0000 (UTC) (envelope-from fw@inotronic.de) Received: from mail.inotronic.de (mail.inotronic.de [77.73.248.111]) by mx1.freebsd.org (Postfix) with ESMTP id 9611B8FC14 for ; Tue, 13 Dec 2011 12:12:56 +0000 (UTC) Received: from phosphorus (mail [77.73.248.111]) by mail.inotronic.de (8.14.5/8.14.3) with ESMTP id pBDCCtc4073203; Tue, 13 Dec 2011 13:12:55 +0100 (CET) (envelope-from fw@inotronic.de) Received: from mail.inotronic.de ([77.73.248.111]) by phosphorus (phosphorus.dmz.inotronic.de [77.73.248.111]) (amavisd-new, port 10024) with LMTP id yZTJWE0TzEqh; Tue, 13 Dec 2011 13:12:47 +0100 (CET) Received: from boron.inotronic.de (boron.inotronic-intern.de [10.1.2.10]) by mail.inotronic.de (8.14.5/8.14.3) with ESMTP id pBDCChAJ073177 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Tue, 13 Dec 2011 13:12:44 +0100 (CET) (envelope-from fw@inotronic.de) Received: from boron.inotronic-intern.de (fw@localhost [127.0.0.1]) by boron.inotronic.de (8.14.4/8.14.4) with ESMTP id pBDCCha8018635; Tue, 13 Dec 2011 13:12:43 +0100 (CET) (envelope-from fw@boron.inotronic-intern.de) Received: (from fw@localhost) by boron.inotronic-intern.de (8.14.4/8.14.4/Submit) id pBDCCheK018634; Tue, 13 Dec 2011 13:12:43 +0100 (CET) (envelope-from fw) Message-Id: <201112131212.pBDCCheK018634@boron.inotronic-intern.de> Date: Tue, 13 Dec 2011 13:12:43 +0100 (CET) From: Frank Wall To: FreeBSD-gnats-submit@FreeBSD.org X-Send-Pr-Version: 3.113 Cc: fw@moov.de Subject: ports/163242: [NEW PORT] databases/autopostgresqlbackup: Make daily, weekly and monthly backups of your PostgreSQL databases X-BeenThere: freebsd-ports-bugs@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Ports bug reports List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 13 Dec 2011 12:20:10 -0000 >Number: 163242 >Category: ports >Synopsis: [NEW PORT] databases/autopostgresqlbackup: Make daily, weekly and monthly backups of your PostgreSQL databases >Confidential: no >Severity: non-critical >Priority: low >Responsible: freebsd-ports-bugs >State: open >Quarter: >Keywords: >Date-Required: >Class: change-request >Submitter-Id: current-users >Arrival-Date: Tue Dec 13 12:20:09 UTC 2011 >Closed-Date: >Last-Modified: >Originator: Frank Wall >Release: FreeBSD 7.3-RELEASE-p7 amd64 >Organization: >Environment: System: FreeBSD 7.3-RELEASE-p7 FreeBSD 7.3-RELEASE-p7 #0: Tue Sep 27 13:10:21 UTC 2011 >Description: A script to take daily, weekly and monthly backups of your PostgreSQL databases using pg_dump. Features: - Backup mutiple databases - Single backup file or to a seperate file for each DB - Compress backup files - Backup remote servers - E-Mail logs WWW: https://sourceforge.net/projects/autopgsqlbackup/ Generated with FreeBSD Port Tools 0.99 >How-To-Repeat: >Fix: Some notes: - non-official patch to version 1.1 fixes some bugs and enhances funtionality - added my self-hosted non-official mirror dl.moov.de (the SF project is quite old...) --- autopostgresqlbackup-1.1.shar begins here --- # This is a shell archive. Save it in a file, remove anything before # this line, and then unpack it by entering "sh file". Note, it may # create directories; files and directories will be owned by you and # have default permissions. # # This archive contains: # # autopostgresqlbackup # autopostgresqlbackup/files # autopostgresqlbackup/files/patch-autopostgresqlbackup.sh.1.0 # autopostgresqlbackup/distinfo # autopostgresqlbackup/pkg-descr # autopostgresqlbackup/Makefile # echo c - autopostgresqlbackup mkdir -p autopostgresqlbackup > /dev/null 2>&1 echo c - autopostgresqlbackup/files mkdir -p autopostgresqlbackup/files > /dev/null 2>&1 echo x - autopostgresqlbackup/files/patch-autopostgresqlbackup.sh.1.0 sed 's/^X//' >autopostgresqlbackup/files/patch-autopostgresqlbackup.sh.1.0 << 'a4d54aa6160943ad051da64778cd37a5' X--- autopostgresqlbackup.sh.orig 2011-11-23 09:22:58.659311063 +0100 X+++ autopostgresqlbackup.sh 2011-12-13 13:03:36.443989828 +0100 X@@ -1,6 +1,6 @@ X-#!/bin/bash X+#!/usr/local/bin/bash X # X-# PostgreSQL Backup Script Ver 1.0 X+# PostgreSQL Backup Script Ver 1.1 X # http://autopgsqlbackup.frozenpc.net X # Copyright (c) 2005 Aaron Axelsen X # X@@ -10,6 +10,8 @@ X # The PostgreSQL changes are based on a patch agaisnt AutoMySQLBackup 1.9 X # created by Friedrich Lobenstock X # X+# Version 1.1 includes additions by Frank Wall . X+# X # This program is free software; you can redistribute it and/or modify X # it under the terms of the GNU General Public License as published by X # the Free Software Foundation; either version 2 of the License, or X@@ -25,13 +27,21 @@ X # Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA X # X #===================================================================== X-# Set the following variables to your system needs X-# (Detailed instructions below variables) X+# IT IS RECOMMENDED TO ***NOT*** CHANGE ANYTHING IN THIS SCRIPT. X+# PUT YOUR OPTIONS INTO A SEPARATE CONFIGURATION FILE: X+# /etc/autopostgresqlbackup.conf -OR- /usr/local/etc/autopostgresqlbackup.conf X #===================================================================== X X # Username to access the PostgreSQL server e.g. dbuser X USERNAME=postgres X X+# Password to access the PostgreSQL server e.g. password X+# NOTE: Having the password in a variable is a security risk. X+# You should consider creating a .pgpass file in the X+# home directory of the account that this script will X+# run as. X+PASSWORD='password' X+ X # Password X # create a file $HOME/.pgpass containing a line like this X # hostname:*:*:dbuser:dbpass X@@ -60,7 +70,6 @@ X # Email Address to send mail to? (user@domain.com) X MAILADDR="root@localhost" X X- X # ============================================================ X # === ADVANCED OPTIONS ( Read the doc's below for details )=== X #============================================================= X@@ -74,6 +83,9 @@ X # Include CREATE DATABASE in backup? X CREATE_DATABASE=yes X X+# Dump database schema separately. X+SEPSCHEMA=no X+ X # Separate backup directory and file for each DB? (yes or no) X SEPDIR=yes X X@@ -83,12 +95,26 @@ X # Choose Compression type. (gzip or bzip2) X COMP=gzip X X+# Choose compression tool. (int or cmd) X+COMPPROG=int X+ X+# Choose compression level. (gzip only) X+COMPLEVEL=5 X+ X # Command to run before backups (uncomment to use) X #PREBACKUP="/etc/pgsql-backup-pre" X X # Command run after backups (uncomment to use) X-POSTBACKUP="bash /home/backups/scripts/ftp_pgsql" X+#POSTBACKUP="bash /home/backups/scripts/ftp_pgsql" X X+# Check configuration files (overwrite defaults). X+if [ -f "autopostgresqlbackup.conf" ] ; then X+ source "autopostgresqlbackup.conf" X+elif [ -f "/etc/autopostgresqlbackup.conf" ] ; then X+ source "/etc/autopostgresqlbackup.conf" X+elif [ -f "/usr/local/etc/autopostgresqlbackup.conf" ] ; then X+ source "/usr/local/etc/autopostgresqlbackup.conf" X+fi X X #===================================================================== X # Options documentation X@@ -206,6 +232,14 @@ X # X # VER 1.0 - (2005-03-25) X # Initial Release - based on AutoMySQLBackup 2.2 X+# VER 1.1 - (2011-12-13) X+# - add support for a configuration file X+# - support separate schema dump X+# - better utilize pg_dump's options X+# - let the user specify a compression level X+# - let the user specify a password for connecting to pgsql X+# - allow the script to run silent by setting MAILCONTENT=quiet X+# - fix small bugs X # X #===================================================================== X #===================================================================== X@@ -221,10 +255,11 @@ X DOM=`date +%d` # Date of the Month e.g. 27 X M=`date +%B` # Month e.g January X W=`date +%V` # Week Number e.g 37 X-VER=1.0 # Version Number X+VER=1.1 # Version Number X LOGFILE=$BACKUPDIR/$DBHOST-`date +%N`.log # Logfile Name X OPT="" # OPT string for use with mysqldump ( see man mysqldump ) X BACKUPFILES="" # thh: added for later mailing X+UNAME_S="`uname -s | tr "[:upper:]" "[:lower:]"`" # identify operating system X X # Create required directories X if [ ! -e "$BACKUPDIR" ] # Check Backup Directory exists. X@@ -254,20 +289,51 @@ X # Saves stdout. X exec > $LOGFILE # stdout replaced with file $LOGFILE. X X+# Only gzip is handled by internal compression. X+[ "$COMP" = "bzip2" ] && COMPPROG=cmd X+ X+# Make sure compression level is valid. X+if [ ! "$COMPLEVEL" -ge "0" -o ! "$COMPLEVEL" -le "9" ]; then X+ echo "Invalid compression level specified ($COMPLEVEL)" X+ COMPLEVEL=5 X+fi X X # Functions X X # Database dump function X dbdump () { X-pg_dump --username=$USERNAME $HOST $OPT $1 > $2 X+if [ "$COMPPROG" = "int" ]; then X+ [ -z "$PASSWORD" ] && pg_dump --username=$USERNAME $HOST --compress=$COMPLEVEL $OPT $1 --file=$2.gz X+ [ ! -z "$PASSWORD" ] && PGPASSWORD=$PASSWORD pg_dump --username=$USERNAME $HOST --compress=$COMPLEVEL $OPT $1 --file=$2.gz X+else X+ [ -z "$PASSWORD" ] && pg_dump --username=$USERNAME $HOST $OPT $1 --file=$2 X+ [ ! -z "$PASSWORD" ] && PGPASSWORD=$PASSWORD pg_dump --username=$USERNAME $HOST $OPT $1 --file=$2 X+fi X+return 0 X+} X+ X+# Schema dump function X+schemadump () { X+[ "$SEPSCHEMA" != "yes" ] && return 0 X+if [ "$COMPPROG" = "int" ]; then X+ [ -z "$PASSWORD" ] && pg_dump --username=$USERNAME $HOST -s -F p $OPT $1 | sed -e 's/DROP SCHEMA public;/-- DROP SCHEMA public;/' -e 's/CREATE SCHEMA public;/-- CREATE SCHEMA public;/' | gzip -$COMPLEVEL > $2.gz X+ [ ! -z "$PASSWORD" ] && PGPASSWORD=$PASSWORD pg_dump --username=$USERNAME $HOST -s -F p $OPT $1 | sed -e 's/DROP SCHEMA public;/-- DROP SCHEMA public;/' -e 's/CREATE SCHEMA public;/-- CREATE SCHEMA public;/' | gzip -$COMPLEVEL > $2.gz X+else X+ [ -z "$PASSWORD" ] && pg_dump --username=$USERNAME $HOST -s -F p $OPT $1 | sed -e 's/DROP SCHEMA public;/-- DROP SCHEMA public;/' -e 's/CREATE SCHEMA public;/-- CREATE SCHEMA public;/' > $2 X+ [ ! -z "$PASSWORD" ] && PGPASSWORD=$PASSWORD pg_dump --username=$USERNAME $HOST -s -F p $OPT $1 | sed -e 's/DROP SCHEMA public;/-- DROP SCHEMA public;/' -e 's/CREATE SCHEMA public;/-- CREATE SCHEMA public;/' > $2 X+fi X return 0 X } X X # Compression function X SUFFIX="" X compression () { X+if [ "$COMPPROG" = "int" ]; then X+ SUFFIX=".gz" X+ return 0 X+fi X if [ "$COMP" = "gzip" ]; then X- gzip -f "$1" X+ gzip -$COMPLEVEL -f "$1" X echo X echo Backup Information for "$1" X gzip -l "$1.gz" X@@ -295,8 +361,8 @@ X echo X fi X X- X-if [ "$SEPDIR" = "yes" ]; then # Check if CREATE DATABSE should be included in Dump X+if [ "$SEPDIR" = "yes" ]; then X+ # Check if CREATE DATABSE should be included in Dump X if [ "$CREATE_DATABASE" = "no" ]; then X OPT="$OPT" X else X@@ -316,12 +382,14 @@ X X # If backing up all DBs on the server X if [ "$DBNAMES" = "all" ]; then X- DBNAMES="`psql -U $USERNAME $HOST -l -A -F: | sed -ne "/:/ { /Name:Owner/d; /template0/d; s/:.*$//; p }"`" X- X+ [ -z "$PASSWORD" ] && DBNAMES="`psql -U $USERNAME $HOST -l -A -F: | sed -ne "/:/ { /Name:Owner/d; /template0/d; s/:.*$//p;}"`" X+ [ ! -z "$PASSWORD" ] && DBNAMES="`PGPASSWORD=$PASSWORD psql -U $USERNAME $HOST -l -A -F: | sed -ne "/:/ { /Name:Owner/d; /template0/d; s/:.*$//p;}"`" X+ X # If DBs are excluded X for exclude in $DBEXCLUDE X do X- DBNAMES=`echo $DBNAMES | sed "s/\b$exclude\b//g"` X+ [ "$UNAME_S" = "linux" ] && DBNAMES=`echo $DBNAMES | sed "s/\b$exclude\b//g"` X+ [ "$UNAME_S" = "freebsd" ] && DBNAMES=`echo $DBNAMES | sed "s/[[:<:]]$exclude[[:>:]]//g"` X done X X MDBNAMES=$DBNAMES X@@ -342,7 +410,6 @@ X if [ $DOM = "01" ]; then X for MDB in $MDBNAMES X do X- X # Prepare $DB for using X MDB="`echo $MDB | sed 's/%/ /g'`" X X@@ -351,58 +418,67 @@ X mkdir -p "$BACKUPDIR/monthly/$MDB" X fi X echo Monthly Backup of $MDB... X+ schemadump "$MDB" "$BACKUPDIR/monthly/$MDB/${MDB}_$DATE.$M.$MDB.schema" X+ compression "$BACKUPDIR/monthly/$MDB/${MDB}_$DATE.$M.$MDB.schema" X dbdump "$MDB" "$BACKUPDIR/monthly/$MDB/${MDB}_$DATE.$M.$MDB.sql" X compression "$BACKUPDIR/monthly/$MDB/${MDB}_$DATE.$M.$MDB.sql" X BACKUPFILES="$BACKUPFILES $BACKUPDIR/monthly/$MDB/${MDB}_$DATE.$M.$MDB.sql$SUFFIX" X+ [ "$SEPSCHEMA" = "yes" ] && BACKUPFILES="$BACKUPFILES $BACKUPDIR/monthly/$MDB/${MDB}_$DATE.$M.$MDB.schema$SUFFIX" X echo ---------------------------------------------------------------------- X done X fi X X for DB in $DBNAMES X do X- # Prepare $DB for using X- DB="`echo $DB | sed 's/%/ /g'`" X- X- # Create Seperate directory for each DB X- if [ ! -e "$BACKUPDIR/daily/$DB" ] # Check Daily DB Directory exists. X- then X- mkdir -p "$BACKUPDIR/daily/$DB" X- fi X- X- if [ ! -e "$BACKUPDIR/weekly/$DB" ] # Check Weekly DB Directory exists. X- then X- mkdir -p "$BACKUPDIR/weekly/$DB" X- fi X- X- # Weekly Backup X- if [ $DNOW = $DOWEEKLY ]; then X- echo Weekly Backup of Database \( $DB \) X- echo Rotating 5 weeks Backups... X- if [ "$W" -le 05 ];then X- REMW=`expr 48 + $W` X- elif [ "$W" -lt 15 ];then X- REMW=0`expr $W - 5` X- else X- REMW=`expr $W - 5` X- fi X- eval rm -fv "$BACKUPDIR/weekly/$DB/week.$REMW.*" X- echo X- dbdump "$DB" "$BACKUPDIR/weekly/$DB/${DB}_week.$W.$DATE.sql" X- compression "$BACKUPDIR/weekly/$DB/${DB}_week.$W.$DATE.sql" X- BACKUPFILES="$BACKUPFILES $BACKUPDIR/weekly/$DB/${DB}_week.$W.$DATE.sql$SUFFIX" X- echo ---------------------------------------------------------------------- X- X- # Daily Backup X- else X- echo Daily Backup of Database \( $DB \) X- echo Rotating last weeks Backup... X- eval rm -fv "$BACKUPDIR/daily/$DB/*.$DOW.sql.*" X- echo X- dbdump "$DB" "$BACKUPDIR/daily/$DB/${DB}_$DATE.$DOW.sql" X- compression "$BACKUPDIR/daily/$DB/${DB}_$DATE.$DOW.sql" X- BACKUPFILES="$BACKUPFILES $BACKUPDIR/daily/$DB/${DB}_$DATE.$DOW.sql$SUFFIX" X- echo ---------------------------------------------------------------------- X- fi X+ # Prepare $DB for using X+ DB="`echo $DB | sed 's/%/ /g'`" X+ X+ # Create Seperate directory for each DB X+ if [ ! -e "$BACKUPDIR/daily/$DB" ] # Check Daily DB Directory exists. X+ then X+ mkdir -p "$BACKUPDIR/daily/$DB" X+ fi X+ X+ if [ ! -e "$BACKUPDIR/weekly/$DB" ] # Check Weekly DB Directory exists. X+ then X+ mkdir -p "$BACKUPDIR/weekly/$DB" X+ fi X+ X+ # Weekly Backup X+ if [ $DNOW = $DOWEEKLY ]; then X+ echo Weekly Backup of Database \( $DB \) X+ echo Rotating 5 weeks Backups... X+ if [ "$W" -le 05 ];then X+ REMW=`expr 48 + $W` X+ elif [ "$W" -lt 15 ];then X+ REMW=0`expr $W - 5` X+ else X+ REMW=`expr $W - 5` X+ fi X+ eval rm -fv "$BACKUPDIR/weekly/$DB/week.$REMW.*" X+ echo X+ schemadump "$DB" "$BACKUPDIR/weekly/$DB/${DB}_week.$W.$DATE.schema" X+ compression "$BACKUPDIR/weekly/$DB/${DB}_week.$W.$DATE.schema" X+ dbdump "$DB" "$BACKUPDIR/weekly/$DB/${DB}_week.$W.$DATE.sql" X+ compression "$BACKUPDIR/weekly/$DB/${DB}_week.$W.$DATE.sql" X+ BACKUPFILES="$BACKUPFILES $BACKUPDIR/weekly/$DB/${DB}_week.$W.$DATE.sql$SUFFIX" X+ [ "$SEPSCHEMA" = "yes" ] && BACKUPFILES="$BACKUPFILES $BACKUPDIR/weekly/$DB/${DB}_week.$W.$DATE.schema$SUFFIX" X+ echo ---------------------------------------------------------------------- X+ X+ # Daily Backup X+ else X+ echo Daily Backup of Database \( $DB \) X+ echo Rotating last weeks Backup... X+ eval rm -fv "$BACKUPDIR/daily/$DB/*.$DOW.sql.*" X+ echo X+ schemadump "$DB" "$BACKUPDIR/daily/$DB/${DB}_$DATE.$DOW.schema" X+ compression "$BACKUPDIR/daily/$DB/${DB}_$DATE.$DOW.schema" X+ dbdump "$DB" "$BACKUPDIR/daily/$DB/${DB}_$DATE.$DOW.sql" X+ compression "$BACKUPDIR/daily/$DB/${DB}_$DATE.$DOW.sql" X+ BACKUPFILES="$BACKUPFILES $BACKUPDIR/daily/$DB/${DB}_$DATE.$DOW.sql$SUFFIX" X+ [ "$SEPSCHEMA" = "yes" ] && BACKUPFILES="$BACKUPFILES $BACKUPDIR/daily/$DB/${DB}_$DATE.$DOW.schema$SUFFIX" X+ echo ---------------------------------------------------------------------- X+ fi X done X echo Backup End `date` X echo ====================================================================== X@@ -414,9 +490,12 @@ X # Monthly Full Backup of all Databases X if [ $DOM = "01" ]; then X echo Monthly full Backup of \( $MDBNAMES \)... X+ schemadump "$MDBNAMES" "$BACKUPDIR/monthly/$DATE.$M.all-databases.schema" X+ compression "$BACKUPDIR/monthly/$DATE.$M.all-databases.schema" X dbdump "$MDBNAMES" "$BACKUPDIR/monthly/$DATE.$M.all-databases.sql" X compression "$BACKUPDIR/monthly/$DATE.$M.all-databases.sql" X BACKUPFILES="$BACKUPFILES $BACKUPDIR/monthly/$DATE.$M.all-databases.sql$SUFFIX" X+ [ "$SEPSCHEMA" = "yes" ] && BACKUPFILES="$BACKUPFILES $BACKUPDIR/monthly/$DATE.$M.all-databases.schema$SUFFIX" X echo ---------------------------------------------------------------------- X fi X X@@ -434,9 +513,12 @@ X fi X eval rm -fv "$BACKUPDIR/weekly/week.$REMW.*" X echo X+ schemadump "$DBNAMES" "$BACKUPDIR/weekly/week.$W.$DATE.schema" X+ compression "$BACKUPDIR/weekly/week.$W.$DATE.schema" X dbdump "$DBNAMES" "$BACKUPDIR/weekly/week.$W.$DATE.sql" X compression "$BACKUPDIR/weekly/week.$W.$DATE.sql" X BACKUPFILES="$BACKUPFILES $BACKUPDIR/weekly/week.$W.$DATE.sql$SUFFIX" X+ [ "$SEPSCHEMA" = "yes" ] && BACKUPFILES="$BACKUPFILES $BACKUPDIR/weekly/week.$W.$DATE.schema$SUFFIX" X echo ---------------------------------------------------------------------- X X # Daily Backup X@@ -445,10 +527,14 @@ X echo X echo Rotating last weeks Backup... X eval rm -fv "$BACKUPDIR/daily/*.$DOW.sql.*" X+ eval rm -fv "$BACKUPDIR/daily/*.$DOW.schema.*" X echo X+ schemadump "$DBNAMES" "$BACKUPDIR/daily/$DATE.$DOW.schema" X+ compression "$BACKUPDIR/daily/$DATE.$DOW.schema" X dbdump "$DBNAMES" "$BACKUPDIR/daily/$DATE.$DOW.sql" X compression "$BACKUPDIR/daily/$DATE.$DOW.sql" X BACKUPFILES="$BACKUPFILES $BACKUPDIR/daily/$DATE.$DOW.sql$SUFFIX" X+ [ "$SEPSCHEMA" = "yes" ] && BACKUPFILES="$BACKUPFILES $BACKUPDIR/daily/$DATE.$DOW.schema$SUFFIX" X echo ---------------------------------------------------------------------- X fi X echo Backup End Time `date` X@@ -488,6 +574,10 @@ X elif [ "$MAILCONTENT" = "log" ] X then X cat "$LOGFILE" | mail -s "PostgreSQL Backup Log for $DBHOST - $DATE" $MAILADDR X+elif [ "$MAILCONTENT" = "quiet" ] X+then X+ # be quiet X+ echo >/dev/null X else X cat "$LOGFILE" X fi a4d54aa6160943ad051da64778cd37a5 echo x - autopostgresqlbackup/distinfo sed 's/^X//' >autopostgresqlbackup/distinfo << 'f28c23ecc04e1c08caefeb40c689221b' XSHA256 (autopostgresqlbackup.sh.1.0) = 09d1dfa547964cd690a66d91ebbe1d2b465c81ecfa2a410eb6c4b47c0f774395 XSIZE (autopostgresqlbackup.sh.1.0) = 17028 f28c23ecc04e1c08caefeb40c689221b echo x - autopostgresqlbackup/pkg-descr sed 's/^X//' >autopostgresqlbackup/pkg-descr << '68a3f14096a7027cd13a24281acc9d65' XA script to take daily, weekly and monthly backups of your PostgreSQL Xdatabases using pg_dump. X XFeatures: X- Backup mutiple databases X- Single backup file or to a seperate file for each DB X- Compress backup files X- Backup remote servers X- E-Mail logs X XWWW: https://sourceforge.net/projects/autopgsqlbackup/ 68a3f14096a7027cd13a24281acc9d65 echo x - autopostgresqlbackup/Makefile sed 's/^X//' >autopostgresqlbackup/Makefile << '9735f609f4e35fd43f4ace27504bd932' X# New ports collection makefile for: autopostgresqlbackup X# Date created: Tue Dec 13 2011 X# Whom: Frank Wall X# X# $FreeBSD$ X# X XPORTNAME= autopostgresqlbackup XPORTVERSION= 1.1 XCATEGORIES= databases XMASTER_SITES= SF/autopgsqlbackup/AutoPostgreSQLBackup/AutoPostgreSQLBackup-1.0/ \ X http://dl.moov.de/freebsd/${PORTNAME}/ XDISTNAME= ${PORTNAME} XEXTRACT_SUFX= .sh.1.0 X XMAINTAINER= fw@moov.de XCOMMENT= Make daily, weekly and monthly backups of your PostgreSQL databases X XRUN_DEPENDS= ${LOCALBASE}/bin/bash:${PORTSDIR}/shells/bash X XNO_BUILD= yes XPLIST_FILES= sbin/autopostgresqlbackup.sh X Xdo-extract: X ${MKDIR} ${WRKSRC} X ${CP} ${DISTDIR}/${DISTFILES} ${WRKSRC} X ${MV} ${WRKSRC}/${PORTNAME}${EXTRACT_SUFX} ${WRKSRC}/${PORTNAME}.sh X Xdo-install: X ${INSTALL_SCRIPT} ${WRKSRC}/${PORTNAME}.sh ${PREFIX}/sbin X X.include 9735f609f4e35fd43f4ace27504bd932 exit --- autopostgresqlbackup-1.1.shar ends here --- >Release-Note: >Audit-Trail: >Unformatted: