|
Hi Pavan, What over my experience turned out to be (incidentally) useful is a vacuum over the whole database(s). I have one that runs every night and when corruption happens, you will notice it because vacuum will die, hopefully noticing you.
As per the fix, I m not
sure. I
think that if you find curruption, you should first understand what is
corrupted. If you are lucky, is an index, and a recreation will fix it for you. But if the corruption
happens on real
data, then the problem must be approached in
some other way(s).
regards, fabio pardi On 11/06/18 15:28, pavan95 wrote:
Hi all, I'm searching a way to detect postgresql corruption on a daily basis. Please provide me 1) a script which detects the corruption in postgres database/instance, 2) and the remedy steps to fix the issue Searched in lot of links and blogs but unable to find a concrete solution And also it will be a very great help to me if I can get in the same way for fragmentation. Please help me regarding this, since it has been a very long time working on this. Thanks in advance. Regards, Pavan -- Sent from: http://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html |
