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 emz00 opened this issue 5 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?

emz00 avatar May 06 '20 11:05 emz00

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?

emz00 avatar Sep 07 '20 07:09 emz00