#!/bin/bash
DATE=$(date '+%Y%m%d');
PG_ARCHIVE=/var/lib/pgsql/9.5/data/pg_arch
PG_DATA=/var/lib/pgsql/9.5/data
PG_HOME=/var/lib/pgsql
#START BACKUP
echo "START BACKUP..............."
psql postgres -c "select pg_start_backup('hot_back')"
cd $PG_HOME
tar zcvf ${PG_HOME}/pg_hotbackup_$DATE.tar.gz $PG_DATA
psql postgres -c "select pg_stop_backup()"
psql postgres -c "select pg_switch_xlog()"
psql postgres -c "select pg_current_xlog_location()"
echo "BACKUP END"
找到个脚本改改
@mashiro 定时备份啊,在后台挂个cron,定时rsync到其他服务器不就完事了
@maolog 额,行吧
你不如直接搞成主从同步数据库
@mashiro 这又回到我第一个问题,开端口……
@maolog 不是,pgdump不就可以了吗,这么复杂是干啥。
pg_dumpall -U postgres > dumpfile