前置條件：
postgreql版本：12+
barman版本：2.+
運行環(huán)境：centos系列加上網(wǎng)
腳本：
結(jié)合末尾的執(zhí)行參數(shù)看更容易理解
cat pg_disaster_recovery_with_barman.sh
#!/bin/bash
set -o nounset #遇到變量不存在，腳本報錯
set -o xtrace # 打印執(zhí)行命令
set -o errexit # 錯誤退出
set -o pipefail # 只要一個子命令失敗铃慷，整個管道命令就失敗漩蟆，腳本就會終止執(zhí)行
target=$1
# 設(shè)置本地yum源
function set_pg_repo(){
echo "[barman-pg]
name=barman-pg-rhel7
baseurl=https://download.postgresql.org/pub/repos/yum/12/redhat/rhel-8-x86_64/
gpgcheck=0" > /etc/yum.repos.d/barman-pg.repo
}
function set_pg_admin_secret(){
echo "${pg_host}:5432:*:${pg_user}:${pg_password}" > ${HOME}/.pgpass
chmod 600 ${HOME}/.pgpass
}
function create_pg_user_barman(){
psql -h ${pg_host} -U ${pg_user} -c "CREATE USER barman WITH superuser LOGIN REPLICATION createdb createrole ENCRYPTED password '${pg_password}';"
}
function install_barman(){
yum install epel-release -y
set_pg_repo
yum install barman -y
yum install postgresql12 -y
}
function config_barman(){
set_pg_repo
install_barman
set_pg_admin_secret
create_pg_user_barman
mkdir -p /var/lib/barman/
echo "${pg_host}:5432:*:barman:${pg_password}" >/var/lib/barman/.pgpass
chown barman:barman /var/lib/barman/.pgpass
chmod 600 /var/lib/barman/.pgpass
if su - barman -c "psql -c 'SELECT version()' -U barman -h ${pg_host} postgres"
then
echo "barman user is ok"
else
echo "barman user in pg is bad"
exit 1
fi
sed -e 's/streaming_barman/barman/' -e "s/=pg/=${pg_host}/" -e 's/;path_prefix/path_prefix/' /etc/barman.d/streaming-server.conf-template > /etc/barman.d/streaming-server.conf
echo "export PATH=\$PATH:/usr/pgsql-12/bin" > /etc/profile.d/pg.sh
source /etc/profile.d/pg.sh
barman receive-wal --create-slot streaming
if ! barman switch-xlog --force --archive --archive-timeout 60 streaming # if failed, do it baragain
then
barman switch-xlog --force --archive --archive-timeout 60 streaming
fi
barman check streaming
}
if test $target = "barman"
then
pg_host=$2
pg_user=$3
pg_password=$4
config_barman
echo "config barman successful"
echo "execute barman backup streaming to start backup"
fi
使用方式
例如
bash pg_disaster_recovery_with_barman.sh barman 10.0.0.1 postgres 123456
備份恢復(fù)
本地恢復(fù)
barman list-backup streaming
chown barman /var/lib/postgresql
barman recover --target-time "2021-07-07 17:56:09+08:00" --target-action promote streaming 20210707T173939 /var/lib/postgresql
#barman recover streaming 20210707T145829 /var/lib/postgresql
chown -R postgres:postgres /var/lib/postgresql
mv -f /opt/data/postgresql/postgresql.auto.conf{.origin,}
mv -f /opt/data/postgresql/postgresql.conf{.origin,}
遠(yuǎn)程恢復(fù)
#為barman用戶生成證書
su - barman -c "ssh-keygen -t rsa -P '' -b 4096 -C 'barman@pg-barman' -m PEM -f /var/lib/barman/pg.pem"
# 把公鑰/var/lib/barman/pg.pem放在pg恢復(fù)的目標(biāo)數(shù)據(jù)庫主機(jī)上有權(quán)限的用戶喻鳄，具體請了解linux公鑰交換認(rèn)證
su - barman -c "cat /var/lib/barman/pg.pem.pub"
#恢復(fù)示例
barman recover --remote-ssh-command "ssh root@10.0.0.1 -i /var/lib/barman/pg.pem" --target-time "2021-07-07 17:56:09+08:00" --target-action promote streaming 20210707T173939 /opt/data/postgresql
