Bug reference: 17218 Logged by: Reijo Suhonen Email address: reijo.suhonen@valtori.fi PostgreSQL version: 14.0 Operating system: Red Hat Enterprise Linux Server 7.9 (Maipo) Description:
Restoring a cluster to a specific point in time does not work. The restore ends with the error message "FATAL, XX000," recovery ended before configured recovery target was reached " and the cluster goes down. The same test with version 12 works normally.
This doesn't look like a bug. You have specified a recovery target (09:28) that's beyond the end of what's in WAL (09:27:20). You shouldn't do that -- if you want to recover until the end of WAL, you shouldn't specify a target at all.
The behaviour of this case changed in PostgreSQL 13 which is probably why you didn't see it before. https://www.postgresql.org/docs/release/13.0/ has the entry "Generate an error if recovery does not reach the specified recovery target (Leif Gunnar Erlandsen, Peter Eisentraut) Previously, a standby would promote itself upon reaching the end of WAL, even if the target was not reached.".