wiki.chpc.ac.za

This is an old revision of the document!

---

# Shell Scripts

[ischeepers@dirisa-dbsvr ~]$ sudo cat /root/backup_userdb.sh 
#!/bin/bash


DOM=$( date "+%d" )
MONTH=$( date "+%b" )
YEAR=$( date "+%Y" )
PREVMONTH=$( date --date='-1 month' "+%b" )

BACKUPDIR=/data/Userdb_backups/pg_dump
FILE=$BACKUPDIR/chpcuser

if [ "$DOM" == "01" ] ; then
  LASTFILE=$( ls -tr /data/Userdb_backups/pg_dump/ | tail -1 )
  echo cp -p  $BACKUPDIR/$LASTFILE  $FILE.$PREVMONTH-$YEAR.sql.bz2
fi

pg_dump --host=localhost -w --username=chpc chpcusers | bzip2 > /data/Userdb_backups/pg_dump/chpcuser.`date "+%a"`.sql.bz2