Bash script which dumps a Postgres DB and uploads it via SFTP

pg_backup.sh

#!/bin/bash
# Purpose: Dumps a PostgreSQL database and uploads it via SFTP to another host.
# Author: Michael Hohl <[email protected]>
# -----------------------------------------------------------------------------

display_usage() {
    echo "Usage: $0 <dbname> <user@stfp-target>"
}

if [ $# -ne 2 ]; then
    display_usage
    exit 1
fi

today=`date +%Y-%m-%d_%H-%M`
pg_dump $1 | gzip > $1_$today.sql.gz
scp $1_$today.sql.gz $2
rm $1_$today.sql.gz