Re: block corruption message in error logs.

Поиск
Список
Период
Сортировка
От vinod kale
Тема Re: block corruption message in error logs.
Дата
Msg-id CAD7GeHQ3OKqn=hXeK1veMw4PD7h87ryUshkzOymDe3wku9D4uQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: block corruption message in error logs.  (Laurenz Albe <laurenz.albe@cybertec.at>)
Список pgsql-admin
Thank you for the clarification. 

On Tue, 9 Jun 2020, 16:35 Laurenz Albe, <laurenz.albe@cybertec.at> wrote:
On Tue, 2020-06-09 at 07:27 +0530, vinod kale wrote:
> I have dought regarding block corruption message in error logs.
> Below is the scenario :-
> If i made changes in table's disk level file so is it possible that it can display in postgres error logs.
> If possible then what are the parameters in postgresql.conf needs to capture it.

The default setting of "log_min_error_messages" will already log such errors.

Of you will only get an error if an SQL statement actually tries to access
the corrupted block.

Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com

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

Предыдущее
От: Laurenz Albe
Дата:
Сообщение: Re: block corruption message in error logs.
Следующее
От: Wells Oliver
Дата:
Сообщение: Understanding JSONB and TOAST tables