Simple shell script to take Postgres database backup and compress it to .gz format

pg_backup_script.sh

#!/bin/sh

# Dump DBs
dir="/path/to/backup/"
date=`date +"%Y_%m_%d_%H_%M_%S"`
filename="database_name_${date}.sql"

cd $dir

echo "\nBackup in progress...\n"

pg_dump -U <postgres_user_name> <database_name> > $filename --no-owner --exclude-table-data=<table_name1>

exitcode=$?

if [ $exitcode -eq 0 ]; then
	echo "Backup completed...\n"
else
	echo "Backup failed with error code ${exitcode}\n"
	exit 0
fi

echo "Archiving backup file...\n"

gzip -c $filename > $filename.gz

exitcode=$?

if [ $exitcode -eq 0 ]; then
	echo "Archive completed...\n"
	rm -rf $filename
else
	echo "Arcive failed with error code ${exitcode}\n"
	exit 0
fi

echo "Find the backup file here ${dir}${filename}.gz \n"

exit 0