我有一个酒保,可以从另一台服务器上安装一个postgres备份。它的配置是:
active: True
archive_mode: on
archived_count: 47588
archiver: True
archiver_batch_size: 0
backup_method: rsync
backup_options: BackupOptions(['exclusive_backup'])
bandwidth_limit: None
check_timeout: 30
compression: gzip
custom_compression_filter: None
custom_decompression_filter: None
disabled: False
failed_count: 0
immediate_checkpoint: True
is_archiving: True
is_superuser: True
last_archived_time: 2018-11-17 14:49:58.810545+03:30
last_archived_wal: 0000000100002ACC0000003B
last_backup_maximum_age: 7 days (latest backup: 6 hours, 3 minutes, 11 seconds )
last_failed_time: None
last_failed_wal: None
max_incoming_wals_queue: None
minimum_redundancy: 1
msg_list: []
network_compression: True
parallel_jobs: 15
path_prefix: None
pgespresso_installed: False
post_archive_retry_script: None
post_archive_script: None
post_backup_retry_script: None
post_backup_script: None
pre_archive_retry_script: None
pre_archive_script: None
pre_backup_retry_script: None
pre_backup_script: None
recovery_options: RecoveryOptions([])
replication_slot: None
replication_slot_support: True
retention_policy: REDUNDANCY 2
retention_policy_mode: auto
reuse_backup: None
...大约几天前,我们在postgres上遇到了一些问题,酒保也没能支持我们。现在,当我列出备份日志时,我会看到以下内容:
20181117T011505 - Sat Nov 17 08:46:53 2018 - Size: 2.2 TiB - WAL Size: 9.8 GiB (tablespaces: ...)
20181116T011506 - Fri Nov 16 08:48:28 2018 - Size: 2.2 TiB - WAL Size: 38.3 GiB (tablespaces: ...)
20181114T011504 - FAILED我检查了postgres表空间,它的大小正好是2.2TB。现在的问题是:
发布于 2018-11-25 09:55:33
使用标准的barman命令:barman status、barman show-backup和barman check-backup。见文档。
https://dba.stackexchange.com/questions/222779
复制相似问题