postgresql物理备份pg_rman使用总结

yum -y install libpq.so
wget https://yum.postgresql.org/9.5/redhat/rhel-7.2-x86_64/postgresql95-libs-9.5.15-1PGDG.rhel7.x86_64.rpm
wget https://github.com/ossc-db/pg_rman/releases/download/V1.3.8/pg_rman-1.3.8-1.pg95.rhel7.x86_64.rpm
rpm -ivh postgresql95-libs-9.5.15-1PGDG.rhel7.x86_64.rpm
rpm -ivh pg_rman-1.3.8-1.pg95.rhel7.x86_64.rpm
mkdir /data/rman_backup
chown postgres:postgres /data/rman_backup
su - postgres
vi .bash_profile

export PGDATA=/data/postgres/data
export PATH=/usr/local/pgsql/bin
export LD_LIBRARY_PATH=/usr/local/pgsql/lib
export BACKUP_PATH=/data/rman_backup
PATH=$PATH:$HOME/.local/bin:$HOME/bin:$PG_PATH

source .bash_profile
pg_rman init -B /data/rman_backup/
全量压缩备份
pg_rman backup -b full -d sde -Z
增量压缩备份
pg_rman backup -b incremental -d sde -Z
查看备份
pg_rman show
备份校验(每次备份完，必须要做一次校验，否则备份集不可用用来恢复，增量备份时也不会用它来做增量比较)
pg_rman validate
还原备份
pg_rman restore --recovery-target-time “2019-07-11 13:48:00”;