Re: Stronger safeguard for archive recovery not to miss data

Поиск
Список
Период
Сортировка
От Laurenz Albe
Тема Re: Stronger safeguard for archive recovery not to miss data
Дата
Msg-id 0e5ab4c3bdedbb926ffbffee4a2858f55ffbc475.camel@cybertec.at
обсуждение исходный текст
Ответ на Re: Stronger safeguard for archive recovery not to miss data  (Fujii Masao <masao.fujii@oss.nttdata.com>)
Ответы RE: Stronger safeguard for archive recovery not to miss data
Список 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




В списке pgsql-hackers по дате отправления:

Предыдущее
От: Joe Conway
Дата:
Сообщение: Re: policies with security definer option for allowing inline optimization
Следующее
От: Zhihong Yu
Дата:
Сообщение: Re: simplifying foreign key/RI checks