#!/bin/bash
#
# Backup a Postgresql database into a daily file.
#

BACKUP_DIR=/home/djoudi/public_html/backupLG/database/postgresql/
DAYS_TO_KEEP=14
FILE_SUFFIX=_pg_backup_fnac.sql
DATABASE=lg
USER=adempiere

FILE=`date +"%Y%m%d%H%M"`${FILE_SUFFIX}

OUTPUT_FILE=${BACKUP_DIR}/${FILE}

# do the database backup (dump)
# use this command for a database server on localhost. add other options if need be.
pg_dump -U ${USER} -p 5436 -h it-dz.net ${DATABASE} -F p  -f ${OUTPUT_FILE}

# gzip the mysql database dump file
gzip $OUTPUT_FILE

# show the user the result
echo "${OUTPUT_FILE}.gz was created:"
ls -l ${OUTPUT_FILE}.gz

# prune old backups
find $BACKUP_DIR -maxdepth 1 -mtime +$DAYS_TO_KEEP -name "*${FILE_SUFFIX}.gz" -exec rm -rf '{}' ';'