zalando / zalando/postgres-operator
Q: Will it be possible to restore to previous minor version? "WAL backup"
Nobody has claimed this yet.
- Dominant language
- Go
- Stars
- 5.2k
- Forks
- 1.1k
- Avg merge
- 2d 16h
- Merged PRs (30d)
- 3
Description
How do you see following?
Q: Will it be possible to restore to a backup of previous minor version of Postgres?
From "WAL backups". WAL archiving / basebackups:
https://postgres-operator.readthedocs.io/en/latest/administrator/#wal-archiving-and-physical-basebackups
Of course, we first scratch install Patroni DB cluster to previous minor version.
Then, after that, we would restore from certain point of time (from a certain "basebackup" etc), where that previous minor version was in use.
Or then we could use cloning, etc., if "simple restore" would not work.
( I have my possible "guess" answers, but I am trying to verify. )
Side note: For major versions, there is separate folder. (E.g. "13" and "14".)
2nd question, does someone know: is wal-g nowadays stabile? It was not, a year ago.
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start with the linked WAL archiving and physical basebackups documentation, then review the issue's questions about restoring a previous PostgreSQL minor version and WAL-G stability. Done would be a verified, project-specific answer describing whether the restore scenario is supported and what limitations apply.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- kubernetes, postgresql
- Domain
- databases, infrastructure
- Issue type
- Feature
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100