barman使用复制槽备份

怼烎@ 2022-02-19 01:23 308阅读 0赞

[http://docs.pgbarman.org/release/2.5/][http_docs.pgbarman.org_release_2.5]

使用复制槽就不用创建公钥及传递公钥了在 barman和pg服务器间

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYW93ZW56aG9uZw_size_16_color_FFFFFF_t_70][]

复制槽和 rsync 最好不要一起使用，一起使用的话 会导致 incoming里的文件爆满不会自动删除（实践是这样的）

搭建测试环境

vlnx151005101  --PG-Primary

vlnx153005101   --PG-Standby

vlnx151000103  - -barman

1、在barman服务器上创建复制槽

barman receive-wal    --create-slot 备份目标机器

比如

barman receive-wal  --create-slot  vlnx151005101.fxiaokeyun.local

Creating physical replication slot 'barman' on server 'vlnx151005101.fxiaokeyun.local'

Replication slot 'barman' created

槽位名 默认  barman

[https://www.postgresql.org/docs/current/warm-standby.html\#STREAMING-REPLICATION-SLOTS][https_www.postgresql.org_docs_current_warm-standby.html_STREAMING-REPLICATION-SLOTS]

也可以在 pg服务器上创建 复制槽

postgres =＃SELECT \* FROM pg\_create\_physical\_replication\_slot('barman');

postgres =＃SELECT slot\_name，slot\_type，active FROM pg\_replication\_slots;

删除复制槽slot

SELECT \* FROM pg\_drop\_replication\_slot('barman');

1.1  在barman 家目录下创建.pgpass 文件，并追加下列内容

![20190415121955135.png][]

![20190415122139961.png][]

cat /etc/barman.conf

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYW93ZW56aG9uZw_size_16_color_FFFFFF_t_70 1][]

2、pg服务器  barman服务器访问白名单配置，及槽位

![2019041512224157.png][]

pg\_hba.conf

\#Allow barman to backup PG from backup server remotely

\#--------------------------------------------------

\# TYPE  DATABASE        USER            ADDRESS                 METHOD

host    all             barman           10.151.0.103/32       md5

host    replication     barman      10.151.0.103/32       md5

/data/pg10/data/postgresql.conf

![20190415121955338.png][]

3、

barman 服务器上配置 可以只对不同的pg服务器设置相关配置项目

![20190415121955346.png][]

![20190415121955392.png][]

\[vlnx153005101.fxiaokeyun.local\]

description = vlnx153005101.fxiaokeyun.local

conninfo = host=vlnx153005101.fxiaokeyun.local user=barman dbname=postgres

backup\_method = postgres

streaming\_conninfo = host=vlnx153005101.fxiaokeyun.local user=barman dbname=postgres

streaming\_archiver = on

slot\_name = barman

path\_prefix = /usr/pgsql-10/bin

\#基于恢复窗口的保留策略可参考：[https://blog.csdn.net/leshami/article/details/15498809][https_blog.csdn.net_leshami_article_details_15498809]

\#retention\_policy = RECOVERY WINDOW OF 1 WEEKS

[http_docs.pgbarman.org_release_2.5]: http://docs.pgbarman.org/release/2.5/
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYW93ZW56aG9uZw_size_16_color_FFFFFF_t_70]: /images/20220219/49aece5669ff438d9be562cafb05ca21.png
[https_www.postgresql.org_docs_current_warm-standby.html_STREAMING-REPLICATION-SLOTS]: https://www.postgresql.org/docs/current/warm-standby.html#STREAMING-REPLICATION-SLOTS
[20190415121955135.png]: /images/20220219/e95e49cad4594f7c896a4513c8d77900.png
[20190415122139961.png]: /images/20220219/b78428399e3f453a8fb9c663015b5199.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYW93ZW56aG9uZw_size_16_color_FFFFFF_t_70 1]: /images/20220219/94f7a1161c9a4d889bb7441bff4c97b0.png
[2019041512224157.png]: /images/20220219/bb72f871e27e44e2b53333db3c450159.png
[20190415121955338.png]: /images/20220219/2428ea68a6154cd9a317278601a6dde0.png
[20190415121955346.png]: /images/20220219/bdbdea3f5547488ba89b11cbd15052eb.png
[20190415121955392.png]: /images/20220219/4d433ca47ab84829a5e024609f527a78.png
[https_blog.csdn.net_leshami_article_details_15498809]: https://blog.csdn.net/leshami/article/details/15498809