PostgreSQL备份工具 - PgBackRest安装部署使用

_BuLuLU

已于 2023-06-10 21:08:00 修改

阅读量469

点赞数

分类专栏： PostgreSQL 文章标签：数据库 postgresql 运维

于 2023-04-17 13:35:05 首次发布

本文链接：https://blog.csdn.net/qq_37531186/article/details/130077822

版权

文章目录

1. 安装依赖、下载安装包

# 依赖工具库
[root@hhb ~]# yum -y install gcc make zlib-devel libxm12-devel openssl-devel bzip2-devel libxml2-devel lz4-devel libzstd-devel libyaml-devel
# 下载安装包
[root@hhb ~]# wget https://github.com/pgbackrest/pgbackrest/archive/release/2.45.tar.gz

2. 编译安装

# 解压
[root@hhb postgresql]# tar -zxvf pgbackrest-release-2.45.tar.gz
[root@hhb postgresql]# chown -R pg143:pg143 pgbackrest-release-2.45
[root@hhb postgresql]# cd pgbackrest-release-2.45/src/

## 创建目录
[root@hhb postgresql]# mkdir -p /opt/pg143/pgbackrest/{conf,log}
[root@hhb postgresql]# chown -R pg143:pg143 /opt/pg143/pgbackrest

## 编译安装
[root@hhb postgresql]# cd pgbackrest-release-2.45/src/
# prefix可以指定也可以不指定，，指定目录和当前src目录都会产生pgbackrest
[root@hhb src]# ./configure --prefix=/opt/pg143/pgbackrest
[root@hhb src]# make -j24 && make install -j24
# 直接放到pg环境中
[root@hhb src]# cp /opt/pg143/pgbackrest/bin/pgbackrest /opt/pg143/postgresql/bin/
[root@hhb src]# chown -R pg143:pg143 /opt/pg143/pgbackrest/bin/pgbackrest
[root@hhb src]# chown -R pg143:pg143 /opt/pg143/pgbackrest

# 简单验证
# 
[root@hhb src]# su - pg143
[pg143@hhb ~]$ pgbackrest
pgBackRest 2.45 - General help

Usage:
    pgbackrest [options] [command]

Commands:
    annotate        Add or modify backup annotation.
    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.
    repo-get        Get a file from a repository.
    repo-ls         List files in a repository.
    restore         Restore a database cluster.
    server          pgBackRest server.
    server-ping     Ping pgBackRest server.
    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.
    verify          Verify contents of the repository.
    version         Get version.

Use 'pgbackrest help [command]' for more information.

3. 配置参数

# 创建备份目录
[pg143@hhb ~]$ mkdir -p /opt/pg143/backup
[root@hhb ~]# mkdir -p /var/spool/pgbackrest
[root@hhb ~]# chown -R pg143:pg143 /var/spool/pgbackrest

# 配置参数
[参数文档](https://pgbackrest.org/configuration.html)
[pg143@hhb ~]$ cat /opt/pg143/pgbackrest/conf/pgbackrest.conf
[global]
# 备份存储目录
repo1-path=/opt/pg143/backup
# 备份日志位置
log-path=/opt/pg143/pgbackrest/log
# 保留全库备份个数
repo1-retention-full=2
# 立即执行检查点，否则，备份将在下一个常规检查点之后开始。
start-fast=y
# 配置异步归档，异步操作更高效，因为它可以重用连接并利用并行性。
archive-async=y

[pg143]
pg1-path=/opt/pg143/data
# pg1-host=152.136.156.227
pg1-user=sa
pg1-port=