03/03/19 18:33
* Postgres: Postgres バックアップスクリプト
#/bin/sh
# PostgreSQL database backup script
# Version 1.0
# Sep. 10, 2002
# sonic <sonic@example.com>
# Dump to DATABASE_NAME_YYMMDD.pgdmp.
# Output log.
# Setting
TARGET_DB='my_datebase your_database' # List target database name.
DIR=/home/postgres
LOG=${DIR}/pgdump.log
BACKUPDIR=${DIR}/dbbackup
# Main routine
echo "pg_dump start." `date` >> ${LOG}
date=`date +%Y%m%d`
for db_name in ${TARGET_DB}
do
DUMP_FILE_PATH=${BACKUPDIR}/${db_name}_${date}.pgdmp
/usr/local/pgsql/bin/pg_dump ${db_name} -b -o -Fc > ${DUMP_FILE_PATH} 2>>${LOG}
echo "Database ${db_name} backup complete." `date` >> ${LOG}
done
echo "pg_dump complete." `date` >> ${LOG}