WAL存档:失败(请确保WAL传送已设置)

Question

我正试着配置Barman作为后援。当我做barman check replica时，我一直得到：

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和Barman2.1；我不知道有什么问题需要帮助吗？以下是我的Barman服务器配置：

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

Answer 1

当遇到像这样的错误时，一定要像在barman switch-xlog --force --archive <server_name>中提到的那样运行酒保文件来验证WAL归档过程。

Answer 2

使用barman switch-wal SERVER --force --archive --archive-timeout 30。

对于流存档，还应该手动执行barman cron来打开receive-wal。否则，您需要等待至少1分钟才能使cron自动生效，而switch-wal命令默认只等待30秒，然后失败。