barman icon indicating copy to clipboard operation
barman copied to clipboard

Passive barman server does not include changes since last WAL switch (no streaming data)

Open loop-evgeny opened this issue 4 years ago • 3 comments

barman 2.10, PostgreSQL 12.2

I've configured an active and a passive barman server, as described under http://docs.pgbarman.org/release/2.10/index.html#geographical-redundancy

When I restore from the passive barman instance I find that only changes up to the last WAL archive (WAL switch) are included. The streaming directory on the active barman server contains a .partial file, which is not in the streaming directory on the passive barman server, so that's probably why.

Why does the passive barman not sync the WAL streaming data? Is this by design or a bug? If by design this should be clearly documented. Would it work if I just manually rsynced the whole barman data directory to another server?

loop-evgeny avatar May 06 '20 11:05 loop-evgeny

Why no response to this 4month old issue?

MichaelDBA avatar Sep 04 '20 16:09 MichaelDBA

Why does the passive barman not sync the WAL streaming data? Is this by design or a bug? If by design this should be clearly documented. Would it work if I just manually rsynced the whole barman data directory to another server?

That is by design and we backup only the archive, which contains only the archived WALs (closed).

In general, geographical redundancy is used in long distance scenarios in case of total disruption of a data centre. If you have specific RPO requirements, for example 5 minute, we suggest you use archive_timeout setting and let WAL files be archived maximum every 5 minutes.

You are right we should probably document it better. Happy to review a documentation patch.

Thanks, Gabriele

gbartolini avatar Sep 04 '20 21:09 gbartolini

Thanks, but could you clarify why this is by design, i.e. what would you expect to go wrong if the passive barman server also rsynced the WAL streaming data?

loop-evgeny avatar Sep 07 '20 07:09 loop-evgeny