Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Questions on wal_retention_policy / removal of WAL files that are not required #902

Open
phebing opened this issue Feb 21, 2024 · 1 comment

Comments

@phebing
Copy link

phebing commented Feb 21, 2024

The Documentation says

IMPORTANT: Currently, Barman implements only the full point in time recovery scenario, by constraining the wal_retention_policy option to main.

Does that mean main is currently the only "option" available, or does it mean "if you want to use the full point in time recovery scenario you have to set wal_retention_policy to main"?

In my scenario I need to be able to recover to the 1st day of the past 18 month and only in the last month a point in time recovery would be nice to have, but not required.
Since I expect the WAL Files to become huge (even when compressed) it would be nice to be able to delete them and set wal_retention_policy to 1 month.
If wal_retention_policy = main is the only option that would mean a retention_policy of 18 month would also keep all WAL files of 18 month, right?

And since setting up WAL archiving is necessary for streaming and rsync backups that means that there is no way to not have any (point in time) WAL if you dont need them?
(And yes I know that I need the WALs that are generated while a backup is being performed and pg_basebackup with option -X stream could give me a usable backup including those. But Barman does not give me such an option as far as I can see it in the docs)

@martinmarques
Copy link
Contributor

I think the need you describe is accomplished with a grandfather-father-son backup schema. We have considered this a possible feature but haven't considered the implementation yet.
Regarding your question on wal_retention_policy it has no usage now, and depending on how we implement GFS, it may or may not be needed.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants