PostgreSQL backups

postgresql_backup.sh

#!/bin/bash
## usage
# default: ./postgresql_backup.sh
# load envs
# Create a file .backup_envs
#  DB_NAME=mydb
#  DB_HOST=myhost
#  DB_PORT=5432
#  DB_USER=my_user
#  DB_PASS="supersecretstring"
source .backup_envs
#
TIMESTAMP=$(date +'%F-%H_%M')
DUMP_PATH=backups

grep "$DB_HOST:$DB_PORT:$DB_NAME:$DB_USER:$DB_PASS" $HOME/.pgpass
if [ $? != '0' ]; then
  echo "Add credentials on pgpass"
  echo "$DB_HOST:$DB_PORT:$DB_NAME:$DB_USER:$DB_PASS" >> $HOME/.pgpass
fi

mkdir -v $DUMP_PATH > /dev/null
# Generate backups
pg_dump -U $DB_USER -h $DB_HOST -p $DB_PORT -F c -b -v -f "$DUMP_PATH/$DB_NAME-$TIMESTAMP.sql" $DB_NAME
# Compress backup
tar -zcvf $DUMP_PATH/backup-$DB_NAME-$TIMESTAMP.tar.gz $DUMP_PATH/$DB_NAME-$TIMESTAMP.sql
# Delete backup
rm -vf $DUMP_PATH/$DB_NAME-$TIMESTAMP.sql