centos7.4配置pgbackrest

1.配置集群Stanza

/etc/pgbackrest/pgbackrest.conf
[demo]
pg1-path=/cddb5.0/data2/
pg1-port=7321
[global]
repo1-cipher-pass=zWaf6XtpjIVZC5444yXB+cgFDFl7MxGlgkZSaoPvTGirhPygu4jOKOXf9LO4vjfO
repo1-cipher-type=aes-256-cbc
repo1-path=/var/lib/pgbackrest
repo1-retention-full=2
[global:archive-push]
compress-level=3
说明：/cddb5.0/data2/为postgresql的数据目录

2.创建资料库

mkdir -p /var/lib/pgbackrest
chmod 750 /var/lib/pgbackrest
chown postgres:postgres /var/lib/pgbackrest

3.配置数据库归档

修改postgresql.conf
archive_command = ‘pgbackrest --stanza=demo archive-push %p’
archive_mode = on
listen_addresses = ‘*’
log_filename = ‘postgresql.log’
log_line_prefix = ‘’
max_wal_senders = 3
wal_level = replica
说明：在postgres.auto.conf文件中添加以上参数，否则不能生效。
需要重新启动数据库让参数生效
[cddb@cddb-node1 ~]$ pg_ctl restart -D /cddb5.0/data2/
Configure Retention&& Repository Encryption

4.创建Stanza

[cddb@cddb-node1 ~]$ pgbackrest --stanza=demo --log-level-console=info stanza-create
2020-02-04 15:02:47.751 P00 INFO: stanza-create command begin 2.23: --log-level-console=info --pg1-path=/cddb5.0/data2 --pg1-port=7321 --repo1-cipher-pass= --repo1-cipher-type=aes-256-cbc --repo1-path=/var/lib/pgbackrest --stanza=demo
2020-02-04 15:02:48.289 P00 INFO: stanza-create command end: completed successfully (541ms)
[cddb@cddb-node1 ~]$ ls -l /var/lib/pgbackrest/archive/demo/

5.检查配置

[cddb@cddb-node1 ~]$ pgbackrest --stanza=demo --log-level-console=info check
2020-02-04 15:05:16.812 P00 INFO: check command begin 2.23: --log-level-console=info --pg1-path=/cddb5.0/data2 --pg1-port=7321 --repo1-cipher-pass= --repo1-cipher-type=aes-256-cbc --repo1-path=/var/lib/pgbackrest --stanza=demo
2020-02-04 15:05:18.892 P00 INFO: WAL segment 0000000A00000001000000EA successfully archived to ‘/var/lib/pgbackrest/archive/demo/11-1/0000000A00000001/0000000A00000001000000EA-75afd62e25a5ba3c2432df878e5e464def642fa0.gz’
2020-02-04 15:05:18.892 P00 INFO: check command end: completed successfully (2083ms)