ODOO Database and File store Backup Script using pgdump

odoo_db_backup.sh

#bin/bash

DBNAME='odoo10_sample'

DATETIME=$(date +"%Y%m%d%H%M%S")
DBFILENAME=${DBNAME}_${DATETIME}
HOMEDIR=`echo $HOME`
MANAGEDIR='/tmp'  # Here i am using tmp folder for test
BACKUPDIR=$MANAGEDIR'/DBBACKUP'
FILESTORE_PATH=$HOMEDIR'/.local/share/Odoo/filestore/'


if [ ! -d "$BACKUPDIR" ]; then
  # Control will enter here if $BACKUPDIR doesn't exist.
  mkdir $BACKUPDIR
fi
if [ "$(stat -c '%a' $BACKUPDIR)" != "777" ]; then
  # Control will enter here if $BACKUPDIR exist change permission.
  sudo chmod 777 $BACKUPDIR
fi

sudo su postgres -c "pg_dump ${DBNAME} | gzip -c > ${BACKUPDIR}'/'${DBFILENAME}.dump.out.gz"


cd $FILESTORE_PATH && tar -zcf $BACKUPDIR'/'$DBFILENAME'.tar.gz' $DBNAME'/' && cd