pgbackrest配置监控、冗余策略

接着上一篇pg恢复文档：https://blog.csdn.net/weixin_41561946/article/details/104439619

八、 pgbackRest配置监控

[root@cddb-node0 example]# pwd
/opt/pgbackrest-release-2.23/doc/example
[root@cddb-node0 example]# ls
pgsql-pgbackrest-info.sql pgsql-pgbackrest-query.sql
[root@cddb-node0 example]# chown -R cddb:cddb *
[root@cddb-node0 example]# chmod -R 755 *
[cddb@cddb-node0 example]$ scp pgsql-pgbackrest-* cddb-node1:/home/cddb/
pgsql-pgbackrest-info.sql
pgsql-pgbackrest-query.sql
[cddb@cddb-node1 ~]$ psql -d SWDS -U swds2014 -p 7321 -f pgsql-pgbackrest-info.sql
CREATE SCHEMA
CREATE FUNCTION
[cddb@cddb-node1 ~]$ psql -d SWDS -U swds2014 -p 7321 -f pgsql-pgbackrest-query.sql
name | last_successful_backup | last_archived_wal
--------±-----------------------±-------------------------
“demo” | 2020-02-04 15:40:46+08 | 0000000A00000001000000F2
(1 row)

九、 pgbackRest冗余策略

1. 全量冗余策略
   repo1-retention-full=2
2. 差异备份冗余策略
   repo1-retention-diff=1
3. 归档策略
   repo1-retention-diff=2
   repo1-retention-full=2

十、 pgbackResth常用脚本

1. 查看备份信息
   [cddb@cddb-node1 cddb5.0]$ pgbackrest info
   stanza: demo
   status: ok
   cipher: aes-256-cbc
   db (current)
   wal archive min/max (11-1): 0000000A00000001000000F8/0000000A00000001000000FC
   full backup: 20200204-163558F
   timestamp start/stop: 2020-02-04 16:35:58 / 2020-02-04 16:46:14
   wal start/stop: 0000000A00000001000000F8 / 0000000A00000001000000F8
   database size: 3.9GB, backup size: 3.9GB
   repository size: 810.3MB, repository backup size: 810.3MB
   full backup: 20200205-142255F
   timestamp start/stop: 2020-02-05 14:22:55 / 2020-02-05 14:30:50
   wal start/stop: 0000000A00000001000000FB / 0000000A00000001000000FB
   database size: 3.9GB, backup size: 3.9GB
   repository size: 810.3MB, repository backup size: 810.3MB
2. 查看备份的详细信息
   [cddb@cddb-node1 cddb5.0]$ pgbackrest --stanza=demo --set=20200205-142255F info
   stanza: demo
   status: ok
   cipher: aes-256-cbc
   db (current)
   wal archive min/max (11-1): 0000000A00000001000000F8/0000000A00000001000000FC
   full backup: 20200205-142255F
   timestamp start/stop: 2020-02-05 14:22:55 / 2020-02-05 14:30:50
   wal start/stop: 0000000A00000001000000FB / 0000000A00000001000000FB
   database size: 3.9GB, backup size: 3.9GB
   repository size: 810.3MB, repository backup size: 810.3MB
   database list: SWDS (16391), nyc_data (48939), postgres (13285)
   tablespaces:
   sw_tab_99 (41059) => /cddb5.0/tablespace/SW_TAB_99