"Henka" <henka@xxxxxxxxxxxxx> writes: >> Other than that it might be interesting to know the values of some server >> parameters: "fsync" and "full_page_writes". Have you ever had this machine >> crash or had a power failure? And what kind of i/o controller is this? > > fsync = off > full_page_writes = default > > Sadly yes, the machine has experienced a power failure about 3 weeks ago > (genset startup problem). With fsync=off this presents a problem wrt safe > recovery, I know... Ugh. The worst part is that you won't even know that there's anything wrong with your data. I would actually suggest that if you run with fsync off and have a power failure or kernel crash you should just immediately restore from your last backup and not risk running with the possibly corrupt database. Honestly this seems like a weird error to occur as a result of crashing with fsync off but anything's possible. More likely is you have records that you have partial transactions in your database, ie, records which were inserted or deleted in a transaction but missing other records that were inserted or deleted in the same transaction. You could probably fix this particular problem by reindexing the corrupted index. But you may never know if some of the data is incorrect. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com
