postgresql之pgbackrest备份恢复

1、安装pgbackrest

yum install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm
yum install epel-release -y
yum install pgbackrest -y
pgbackrest version

2、创建存储库

mkdir -p /data/pg_backup/pgbackrest
chmod -R 750 /data/pg_backup/pgbackrest/
mkdir -p /data/pg_backup/log/pgbackrest
chown postgres:postgres /data/pg_backup/log/pgbackrest/
chmod -R 700 /data/pg_backup/log/pgbackrest/

3、设置归档模式

vi $PGDATA/postgresql.auto.conf
...
archive_mode = on
archive_command = 'pgbackrest --stanza=demo archive-push %p'
wal_level = replica
重启数据库
pg_ctl -D /home/postgresql/data -l /home/postgresql/data/logfile restart

4、配置pgbackrest.conf

vi /etc/pgbackrest.conf
[global]
repo-path=/data/pg_backup/pgbackrest/
backup-user=postgres
retention-full=