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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general