本篇文章主要介绍了" postgresql 10数据库备份 pg_probackup 简明jrs看球网直播吧_低调看直播体育app软件下载_低调看体育直播"，主要涉及到方面的内容，对于其他数据库感兴趣的同学可以参考一下：
测试环境说明OS：CentOS Linux release 7.3.1611 (Core) X64PG：pg10 beta3 source installpg_...
测试环境说明
OS：CentOS Linux release 7.3.1611 (Core) X64
PG：pg10 beta3 source install
pg_probackup: 2.0.3 source install
建立归档备份目录
[postgres@masterdb ~]# mkdir /backupdir
[postgres@masterdb ~]# chown postgres.postgres -R /backupdir
数据库参数配置
### - Archiving - ###
archive_mode = on
archive_command = 'pg_probackup archive-push -B /backupdir --instance pg10 --wal-file-path %p --wal-file-name %f'
### default ###
max_wal_senders = 10
hot_standby = on
full_page_writes = on
初始化备份目录
[postgres@masterdb ~]# su - postgres
[postgres@masterdb ~]$ pg_probackup init -B /backupdir
INFO: Backup catalog '/backupdir' successfully inited
添加备份实例目录
[postgres@masterdb ~]$ pg_probackup add-instance -B /backupdir -D /pgdata10/ --instance pg10
INFO: Instance 'pg10' successfully inited
显示备份实例配置
[postgres@masterdb ~]$ pg_probackup show-config -B /backupdir --instance pg10
#Backup instance info
PGDATA = /pgdata10/
system-identifier = 6460633300993501667
#Connection parameters:
PGDATABASE = postgres
#Replica parameters:
#Logging parameters:
#Retention parameters:
#Compression parameters:
compress-algorithm = none
compress-level = 6
[postgres@masterdb ~]$ pg_probackup backup -B /backupdir -b full --instance pg10
INFO: wait for pg_stop_backup()
INFO: Backup OVKYC7 completed
[postgres@masterdb ~]$
增量备份
[postgres@masterdb ~]$ pg_probackup backup -B /backupdir -b PAGE --instance pg10
INFO: wait for LSN 0/4000028 in archived WAL segment /backupdir/wal/pg10/000000010000000000000004
INFO: wait for pg_stop_backup()
