PostgreSQL高可用架构演进 - 数据库备份机制

VIP

archive_mode: 'on'archive_command: pgbackrest --stanza=itc archive-push %p

$PGDATA/postgres.conf

Sync

Postgres

pgbackrest

WAL Sender

22

Keepalived

5493

[itc]pg1-path=/var/lib/postgresql/12/data[global]log-level-file=inforepo1-host-user=postgresrepo1-host=pgbackrest 

pg3

/etc/pgbackrest/pgbackrest.conf

pg1

patroni

Push WAL

pgBackRest Repo　

[itc]pg1-path=/var/lib/postgresql/12/datapg1-host=pg1201pg3-path=/var/lib/postgresql/12/datapg3-host=pg1203[global]repo1-path=/postgresql/12repo1-retention-full=2backup-standby=ystart-fast=yrepo1-type=s3repo1-s3-verify-tls=nrepo1-s3-endpoint=infra-oss.itc.inventecrepo1-s3-bucket=infra-backuprepo1-s3-region=eu-west-3repo1-s3-key=backuprepo1-s3-key-secret=restore((repo1-s3-uri-style=path

pg2

Minio

/etc/pgbackrest/pgbackrest.conf

SSH

PG Cluster

Etcd(V3)

Pull Backup