Re: block corruption message in error logs.

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: vinod kale <vinod16895(at)gmail(dot)com>, pgsql-admin(at)postgresql(dot)org
Cc: vvkgadge56(at)gmail(dot)com
Subject: Re: block corruption message in error logs.
Date: 2020-06-09 11:05:50
Message-ID: 56548c641f4c30cdc4950c00d1988f7deda36e6c.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message vinod kale 2020-06-09 19:17:04 Re: block corruption message in error logs.
Previous Message Antonio Gomez 2020-06-09 02:29:23 Create a non-owner administrator in rds postgresql