2009年4月アーカイブ

cd /usr/local/sbin
sudo wget http://tach.arege.net/software/pdumpfs-clean/pdumpfs-clean
sudo chmod 755 pdumpfs-clean
pdumpfs-clean [バックアップ先ディレクトリ]

pdumpfs-clean --keep 5Y12M18W14D [バックアップ先ディレクトリ]

#/bin/sh

##################################################
# PostgreSQL database backup script
#
# In this script, pg_dump command execute by "postgres" user
# Dump to DB_NAME.YYMMDD.dump
# Delete expired dump file
# Output log file.
##################################################

##################################################
# Settings
PG=/var/lib/postgresql/
PGDATA=$PG/8.3/main/
PGBIN=/usr/bin
PGLIB=/usr/lib
PATH="$PATH":$PGBIN
export LD_LIBRARY_PATH="$LD_LIBRARY_PATH":$PGLIB
export PGLIB=$PGLIB
export PGDATA=$PGDATA

# space separated value: databases and backup directories (full path)
DB_NAMES="movabletype"
BAK_DIRS="/backup/postgresql/daily"
WK_DIR=$PG

# log file path
LOG="/root/pg_dump_daily.log"

# number of backup file
BAK_NUM=15
##################################################

##################################################
# Main routine
TODAY=`date +%Y%m%d`

echo "@@@ Start Database Backup [ `date +%Y/%m/%d` ] @@@" | tee -a $LOG

# backup each "DB_NAMES"
for DB_NAME in $DB_NAMES
do
  CNT_DIR=1
  CP_SRC=""
  CP_DST=""

  # backup to each "BAK_DIRS"
  for BAK_DIR in $BAK_DIRS
  do
    if [ $CNT_DIR -eq 1 ]; then

      # create dump command
      COM="pg_dump -S postgres -Fp $DB_NAME"
      if [ $DB_NAME = "ALL" ]; then
        COM="pg_dumpall -S postgres"
      fi

      # execute dump command
      echo "[" `date +%Y/%m/%d_%H:%M:%S` "] $COM [start]" | tee -a $LOG
      DUMP_FILE_PATH=$WK_DIR/$DB_NAME.$TODAY.dump
      su -l postgres -s /bin/sh -c "$PGBIN/$COM > $DUMP_FILE_PATH | tee -a $LOG"
      mv $DUMP_FILE_PATH $BAK_DIR
      echo "[" `date +%Y/%m/%d_%H:%M:%S` "] $COM [done]" | tee -a $LOG
      CP_SRC=$DUMP_FILE_PATH
    else
      # copy dump file to other BAK_DIRS
      CP_DST=$BAK_DIR/$DB_NAME.$TODAY.dump
      echo "[" `date +%Y/%m/%d_%H:%M:%S` "] Copy dump file to $BAK_DIR [start]" | tee -a $LOG
      cp $CP_SRC $CP_DST | tee -a $LOG
      echo "[" `date +%Y/%m/%d_%H:%M:%S` "] Copy dump file to $BAK_DIR [done]" | tee -a $LOG
    fi

    # delete old backup files
    LS=`ls -r $BAK_DIR/$DB_NAME.*.dump`
    CNT=1
    for FILE in $LS
    do
      if [ $CNT -gt $BAK_NUM ]; then
        rm -f $FILE | tee -a $LOG
        echo "[" `date +%Y/%m/%d_%H:%M:%S` "] Delete expired dump file [$FILE]" | tee -a $LOG
      fi
      CNT=`expr $CNT + 1`
    done

    CNT_DIR=`expr $CNT_DIR + 1`
  done

done
echo "@@@ Finish @@@" | tee -a $LOG
##################################################