Postgresql备份及还原 shell脚本

导出脚本

# define variables
DB_INSTALL_DIR='/opt/abc/web/components/postgresql11linux64.1'
# DB_TYPE='PostgreSQL'
DB_SERVER='10.33.43.77'
DB_PORT='7092'
DB_INSTANCE='testdb'
DB_USER='user'
DB_STORAGE='/opt/postgres/backup'

# enter password
export PGPASSWORD='abc'

# change to the bin dir
cd $DB_INSTALL_DIR/bin

# mkdir
if [ ! -d $DB_STORAGE ];then
   mkdir -p $DB_STORAGE
fi

# run pg_dump
echo 'cncgdb pgdump start......'
./pg_dump -h ${DB_SERVER} -U ${DB_USER} -p ${DB_PORT} ${DB_INSTANCE} -Fc > $DB_STORAGE/dbBak.dmp
echo 'db pgdump end......'

导入脚本

# define variables
DB_INSTALL_DIR='/opt/acc/web/components/postgresql11linux64.1'
# DB_TYPE='PostgreSQL'
DB_SERVER='10.33.143.138'
DB_PORT='7092'
DB_INSTANCE='db'
DB_USER='db_user'
DB_STORAGE='/opt/postgres/backup'

# enter password
export PGPASSWORD='tyg'

# change to the bin dir
cd $DB_INSTALL_DIR/bin

# run pg_dump
echo 'acsncgdb pgrestore start......'
./pg_restore -h ${DB_SERVER} -U ${DB_USER} -p ${DB_PORT} -d ${DB_INSTANCE}  $DB_STORAGE/dbBak1.dmp
echo 'db pgrestore end......'