On 7/1/20 4:27 PM, David Steele wrote:
Here's a thought. What if we just stored the oldest starting LSN and a count of how many backups have been requested. When the backup ends it checks that backup count is > 0 and starting LSN is <= its starting LSN. If not, it throws an error. When backups go to 0 FPWs are turned off if they were off before the first backup.
To be clear, the min starting LSN only needs to be reset when incrementing total running backups from 0 to 1. What we are recording here is the LSN since FPWs were enabled. As long as it is <= the start LSN of the backup when it ends then all is well (I think).
Regards, -- -David da...@pgmasters.net
