本文介绍了WAL归档文件:FAILED(请确保已设置WAL装运)的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我正在尝试配置Barman进行备份。当我执行 barman检查副本时,我会不断得到:

I am trying to configure Barman to backup. When I do a barman check replica I keep getting:

Server replica:
WAL archive: FAILED (please make sure WAL shipping is setup)
PostgreSQL: OK
superuser: OK
wal_level: OK
directories: OK
retention policy settings: OK
backup maximum age: FAILED (interval provided: 1 day, latest backup age: No available backups)
compression settings: OK
failed backups: OK (there are 0 failed backups)
minimum redundancy requirements: FAILED (have 0 backups, expected at least 2)
ssh: OK (PostgreSQL server)
not in recovery: FAILED (cannot perform exclusive backup on a standby)
archive_mode: OK
archive_command: OK
continuous archiving: OK
archiver errors: OK

我正在使用Postgresql 9.6和barman 2.1;我不确定有人可以提供什么帮助?
这是我的Barman服务器配置:

I am using Postgresql 9.6 and barman 2.1; I am not sure as to what the issue is could someone help?Here is my Barman server configuration:

description = "Database backup"
conninfo = host=<db-ip> user=postgres dbname=db
backup_method = rsync
ssh_command = ssh postgres@<db-ip>
archiver = on


推荐答案

barman check 通过断言归档中确实有东西来尝试确认归档设置正确。但是,WAL段通常仅在填满后才存档,并且如果您的服务器空闲,则永远不会发生。

barman check tries to confirm that archiving is set up correctly by asserting that there's actually something in the archive. However, WAL segments are generally only archived once they're filled up, and if your server is idle, this is never going to happen.

要解决此问题,Barman提供一个命令来强制执行分段开关,等待完整的WAL出现,然后立即将其归档:

To work around this, Barman provides a command to force a segment switch, wait for the completed WAL to show up, and then archive it immediately:

barman switch-xlog --force --archive replica

这篇关于WAL归档文件:FAILED(请确保已设置WAL装运)的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

06-04 07:25