Export:
#pg_dump dumps a database as a text file or to other formats. #!/bin/bash export SCRIPT_NAME=`basename $0` export HOST=`uname -n` export TS=`date +\%m.\%d.\%y\_%H_%M_%S` export RUN_DATE=`date +\%m.\%d.\%y` export RUN_DIR=. export LOG_DIR=/tmp export DUMPDIR=/pgdata/export export JOB_NAME="ExportPGDB" export VERSION=1.0.0 export LOGFILE=${LOG_DIR}/${SCRIPT_NAME}_${TS}.log exec &> ${LOGFILE} echo "Starting export job at " `date` pg_dump -Fd musicdb -n music -v -f ${DUMPDIR}/mussikkdbexport -j 2 echo "Ending job at " `date` exit
Import:
# pg_restore - restore a PostgreSQL database from an archive file created by pg_dump #!/bin/bash export SCRIPT_NAME=`basename $0` export HOST=`uname -n` export TS=`date +\%m.\%d.\%y\_%H_%M_%S` export RUN_DATE=`date +\%m.\%d.\%y` export RUN_DIR=. export LOG_DIR=/tmp export DUMPDIR=/pgdata/export export JOB_NAME="ImportPGDB" export VERSION=1.0.0 export LOGFILE=${LOG_DIR}/${SCRIPT_NAME}_${TS}.log exec &> ${LOGFILE} echo "Starting job at " `date` pg_restore ${DUMPDIR}/mussikkdbexport -C -c -d postgres -j 4 -v pg_restore ${DUMPDIR}/mussikkdbexport -c -d musicdb -j 4 -v echo "Ending job at " `date` exit
More articles on pg_dump and pgrestore:
No comments:
Post a Comment