postgres_backup.bash

#!/bin/sh

BACKUP_DIR='/var/lib/pgsql/backups/'

FINAL_FILE='backup.gz'

TMP_FILE='tmp.gz'

BACKUP_TMP_FILE="$BACKUP_DIR$TMP_FILE"

BACKUP_FILE="$BACKUP_DIR$FINAL_FILE"

DB_NAME='production_database' 
if [ -e $BACKUP_TMP_FILE ]

then

  rm $BACKUP_TMP_FILE

fi 

pg_dump -i $DB_NAME | gzip > $BACKUP_TMP_FILE 
if [ -e $BACKUP_TMP_FILE ] && [ -e $BACKUP_FILE ]

then

  rm $BACKUP_FILE

fi 

mv $BACKUP_TMP_FILE $BACKUP_FILE