block corruption message in error logs.

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

block corruption message in error logs.

vinod kale
Hello Team,

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.

--
Thanks & Regards,
Vinod Kale
Reply | Threaded
Open this post in threaded view
|

Re: block corruption message in error logs.

Laurenz Albe
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



Reply | Threaded
Open this post in threaded view
|

Re: block corruption message in error logs.

vinod kale
Thank you for the clarification. 

On Tue, 9 Jun 2020, 16:35 Laurenz Albe, <[hidden email]> 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