postgresql 10数据库备份 pg_probackup 简明教程
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了postgresql 10数据库备份 pg_probackup 简明教程，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含6291字，纯文字阅读大概需要9分钟。
内容图文
测试环境说明
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()
INFO: Backup OVKYME completed
[postgres@masterdb ~]$
显示备份
[postgres@masterdb ~]$ pg_probackup show -B /backupdir
BACKUP INSTANCE ‘pg10‘
===============================================================================================================================
Instance ID Recovery time Mode WAL Current/Parent TLI Time Data Start LSN Stop LSN Status
===============================================================================================================================
pg10 OVKYME 2017-09-01 10:51:56 PAGE ARCHIVE 1 / 0 8s 4407kB 0/4000028 0/50000F0 OK
pg10 OVKYC7 2017-09-01 10:45:57 FULL ARCHIVE 1 / 0 17s 31MB 0/2000060 0/2000198 OK
[postgres@masterdb ~]$
验证备份
[postgres@masterdb ~]$ pg_probackup validate -B /backupdir --instance pg10
INFO: Validate backups of the instance ‘pg10‘
INFO: Validate backup OVKYME
INFO: backup validation completed successfully
INFO: Validate backup OVKYC7
INFO: backup validation completed successfully
INFO: All backups are valid
[postgres@masterdb ~]$
恢复备份
[postgres@masterdb pgdata10]$ pg_probackup restore -B /backupdir --instance pg10 -D /pgdata10/
INFO: backup validation completed successfully
配置保存期限
[postgres@masterdb ~]$ pg_probackup set-config -B /backupdir --instance pg10 --retention-redundancy 2 --retention-window 7
[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:
retention-redundancy = 2
retention-window = 7
#Compression parameters:
compress-algorithm = none
compress-level = 6
[postgres@masterdb ~]$
并行备份
full
[postgres@masterdb ~]$ pg_probackup backup -B /backupdir --instance pg10 -b FULL -j 4
INFO: wait for pg_stop_backup()
INFO: Backup OVL360 completed
[postgres@masterdb ~]$
incremental
[postgres@masterdb ~]$ pg_probackup backup -B /backupdir --instance pg10 -b page -j 6
INFO: wait for LSN 0/B000028 in archived WAL segment /backupdir/wal/pg10/00000002000000000000000B
INFO: wait for pg_stop_backup()
INFO: Backup OVL3BK completed
[postgres@masterdb ~]$
[postgres@masterdb ~]$
[postgres@masterdb ~]$ pg_probackup show -B /backupdir --instance pg10
===============================================================================================================================
Instance ID Recovery time Mode WAL Current/Parent TLI Time Data Start LSN Stop LSN Status
===============================================================================================================================
pg10 OVL3BK 2017-09-01 12:33:24 PAGE ARCHIVE 2 / 1 6s 4417kB 0/B000028 0/C0000F0 OK
pg10 OVL360 2017-09-01 12:30:11 FULL ARCHIVE 2 / 1 13s 31MB 0/9000060 0/9000198 OK
pg10 OVKYME 2017-09-01 10:51:56 PAGE ARCHIVE 1 / 0 8s 4407kB 0/4000028 0/50000F0 OK
pg10 OVKYC7 2017-09-01 10:45:57 FULL ARCHIVE 1 / 0 17s 31MB 0/2000060 0/2000198 OK
[postgres@masterdb ~]$
restore
[postgres@masterdb ~]$ pg_probackup restore -B /backupdir --instance pg10 -D /pgdata10/ -j 6
INFO: backup validation completed successfully
INFO: Restore of backup OVL3BK completed.
[postgres@masterdb ~]$ pg_probackup show -B /backupdir --instance pg10 -D /pgdata10
===============================================================================================================================
Instance ID Recovery time Mode WAL Current/Parent TLI Time Data Start LSN Stop LSN Status
===============================================================================================================================
pg10 OVL3BK 2017-09-01 12:33:24 PAGE ARCHIVE 2 / 1 6s 4417kB 0/B000028 0/C0000F0 OK
pg10 OVL360 2017-09-01 12:30:11 FULL ARCHIVE 2 / 1 13s 31MB 0/9000060 0/9000198 OK
pg10 OVKYME 2017-09-01 10:51:56 PAGE ARCHIVE 1 / 0 8s 4407kB 0/4000028 0/50000F0 OK
pg10 OVKYC7 2017-09-01 10:45:57 FULL ARCHIVE 1 / 0 17s 31MB 0/2000060 0/2000198 OK
[postgres@masterdb ~]$
本文出自 “yiyi” 博客，请务必保留此出处http://heyiyi.blog.51cto.com/205455/1961899
postgresql 10数据库备份 pg_probackup 简明教程
标签：pg_probackup postgresql 10
本文系统来源：http://heyiyi.blog.51cto.com/205455/1961899
内容总结
以上是互联网集市为您收集整理的postgresql 10数据库备份 pg_probackup 简明教程全部内容，希望文章能够帮你解决postgresql 10数据库备份 pg_probackup 简明教程所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。