Postgres backup script

backup_postgres.sh

#   Copyright 2012 Peter Doyle (petedoyle at gmail.com)
#
#   Licensed under the Apache License, Version 2.0 (the "License");
#   you may not use this file except in compliance with the License.
#   You may obtain a copy of the License at
#
#       http://www.apache.org/licenses/LICENSE-2.0
#
#   Unless required by applicable law or agreed to in writing, software
#   distributed under the License is distributed on an "AS IS" BASIS,
#   WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
#   See the License for the specific language governing permissions and
#   limitations under the License.

# Run this as the user postgres runs as ("postgres" on ubuntu)

#!/bin/bash
if [ -z "$1" ]
then
        FILENAME=pg_dumpall_$(date +"%Y%m%d-%H:%M:%S").sql.gz
else
        FILENAME=$1
fi

BUCKET_PATH=s3://your.s3.bucket/backups/postgres
FQ_FILENAME=/var/lib/postgres/backups/$FILENAME
pg_dumpall | gzip -c > $FQ_FILENAME

s3cmd --config=/var/lib/postgres/scripts/s3cfg --acl-private --encrypt put $FQ_FILENAME $BUCKET_PATH/$FILENAME.gpg 
rm -f $FQ_FILENAME