锐客网

  1. 首页 > it技术 > >

postgresql|centos7.4安装pgbackrest备份软件

一、pgbackRest介绍 【postgresql|centos7.4安装pgbackrest备份软件】pgBackRest旨在成为一种简单，可靠的备份和还原解决方案，通过利用针对特定数据库需求进行了优化的算法，可以无缝地扩展到最大的数据库和工作负载。
pgBackRest v2.23是当前的稳定版本。发行说明在“ 发行”页面上。v1的文档可以在这里找到。v1没有计划进一步的发行版，因为v2与v1选项和存储库向后兼容。
二、pgbackRest特征 1.并行备份和还原
2.本地或远程操作
3.完整，增量和差异备份
4.备份轮换和存档到期
5.备份完整性
6.页面校验和
7.备份简历
8.流压缩和校验和
9.增量还原
10.并行，异步WAL Push＆Get
11.表空间和链接支持
12.加密
13.与PostgreSQL > = 8.3的兼容性
三、pgbackRest下载地址 https://github.com/pgbackrest/pgbackrest/releases/tag/release/2.23
四、pgbackRest安装 [root@cddb-node0 opt]# tar -xvf pgbackrest-release-2.23.tar.gz
yum install make gcc postgresql-devel openssl-devel libxml2-devel
构建 ?配置并编译pgBackRest
cd /build/pgbackrest-release-2.23/src && ./configure && make
[root@cddb-node0 src]# scp pgbackrest cddb-node1:/usr/bin/
说明：在其他主机上编译好后，直接拷贝到需要使用的备份主机上使用即可
[root@cddb-node1 ~]# chmod 755 /usr/bin/pgbackrest
[root@cddb-node1 ~]# mkdir -p -m 770 /var/log/pgbackrest
[root@cddb-node1 ~]# chown cddb:cddb /var/log/pgbackrest
[root@cddb-node1 ~]# mkdir -p /etc/pgbackrest
[root@cddb-node1 ~]# mkdir -p /etc/pgbackrest/conf.d
[root@cddb-node1 ~]# touch /etc/pgbackrest/pgbackrest.conf
[root@cddb-node1 ~]# chmod 640 /etc/pgbackrest/pgbackrest.conf
[root@cddb-node1 ~]# chown cddb:cddb /etc/pgbackrest/pgbackrest.conf
[cddb@cddb-node1 ~]$ pgbackrest
pgBackRest 2.23 - General help
Usage:
pgbackrest [options] [command]
Commands:
archive-get Get a WAL segment from the archive.
archive-push Push a WAL segment to the archive.
backup Backup a database cluster.
check Check the configuration.
expire Expire backups that exceed retention.
help Get help.
info Retrieve information about backups.
restore Restore a database cluster.
stanza-create Create the required stanza data.
stanza-delete Delete a stanza.
stanza-upgrade Upgrade a stanza.
start Allow pgBackRest processes to run.
stop Stop pgBackRest processes from running.
version Get version.
Use ‘pgbackrest help [command]’ for more information.

    推荐阅读


    上一篇：uniapp 使用webview

    下一篇：centos7.4+postgresql11.6+timescaledb1.7