导出脚本
# 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......'