Re: Stronger safeguard for archive recovery not to miss data - Mailing list pgsql-hackers

On Thu, 2021-04-01 at 17:25 +0900, Fujii Masao wrote:
> Thanks for updating the patch!
> 
> +                                errhint("Use a backup taken after setting wal_level to higher than minimal "
> +                                                "or recover to the point in time before wal_level becomes minimal
eventhough it causes data loss")));
 
> 
> ISTM that "or recover to the point in time before wal_level was changed
>   to minimal even though it may cause data loss" sounds better. Thought?

I would reduce it to

"Either use a later backup, or recover to a point in time before \"wal_level\" was set to \"minimal\"."

I'd say that we can leave it to the intelligence of the reader to
deduce that recovering to an earlier time means more data loss.

Yours,
Laurenz Albe