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