Re: PostgreSQL 'Corruption & Fragmentation' detection andresolution/fix

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

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