Siddharth Shah <siddharth(dot)shah(at)elitecore(dot)com> wrote:
> * fsync is off*
If you are running the database with fsync off and there is any sort
of unusual termination, your database will probably be corrupted. I
recommend restoring from your last good backup. If you don't have
one, recovery is going to be painful; I recommend contracting with
one of the many companies which off PostgreSQL support. (I'm not
affiliated with any of them.)
> I have tried with making fsync on
That may help prevent further corruption, but will do nothing to
help recover from the damage already done.
> Postgres Version : 8.4.3 (Migrated data from 8.4.1)
What do you mean by that? You installed 8.4.3 and reindexed hash
indexes?
> What can be issue ? Is it issue coming after database table
> corruption
Yes.
> Can fsync on can prevent such (corruption) scenarios ?
Yes.
-Kevin