db_backup

#!/bin/bash
#
# Dump script for PostgreSQL databases, Fredrik Welander 2013
#
# Run as postgres
# USAGE: db_backup [database] [user] [dest path/filename]
# CRON EXAMPLE: 
# 00 01 * * * postgres      /usr/local/sbin/db_backup mydb myuser /var/db_backup/mydb_daily.pgdump

if [ $# -ne 3 ]
then
	echo "USAGE: db_backup [database] [user] [dest path/filename]"
	exit
fi

DATABASE=$1
USER=$2
PGPORT="5432"
# Does not work reliably:
#PGPORT=`pg_lsclusters | grep online |awk '{print $3}'`
DUMPFILE="$3"
DUMPSTRING="pg_dump --host localhost --port $PGPORT --username $USER --format custom --blobs --file $DUMPFILE $DATABASE"
echo $DUMPSTRING

$DUMPSTRING