Yogvinder Singh wrote:
> Pavan,
>
> What is the possible reason for the data corruption?
Yogvinder - you haven't provided any information for people to identify
what is corrupted let alone why it is corrupted. Like I said in my reply
on the 7th - it's either hardware problems or a bug in the code.
Tracking down precisely what happened is going to be a lengthy and
complicated process even assuming you have all the tools in place, good
logging etc. Given that you're running 7.3.2 it's unlikely that that is
the case.
Since you're running 7.3.2 and the last release for 7.3 is 7.3.21 you've
chosen to run without 18 sets of bug-fixes issued over a period of five
years.
Have you read the release-notes for those versions and satisfied
yourself that none of the changes affect you?
http://www.postgresql.org/docs/8.3/static/release.html
If you are not 100% certain that those changes are useless to you,
follow the advice everyone is giving and upgrade to the 7.3.21 as soon
as is practical.
--
Richard Huxton
Archonet Ltd
