Q: Will it be possible to restore to previous minor version? "WAL backup"

[Samusername]

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.

[Samusername]

"Restore in place" has some steps,

https://github.com/zalando/postgres-operator/blob/master/docs/user.md

spec:

[...]

clone: cluster: "acid-minimal-cluster" # the same as metadata.name above! uid: "<original_UID>" timestamp: "2022-04-01T10:11:12.000+00:00"

[FxKu]

Try clone section with s3_wal_path pointing to WAL location of previous major version.