"Florian Weimer" <fw@xxxxxxxxxxxxx> wrote > > Anyway, how would be the chances for PostgreSQL to detect such a > corruption on a heap or index data file? It's typically hard to > detect this at the application level, so I don't expect wonders. I'm > just curious if using PostgreSQL would have helped to catch this > sooner. > PostgreSQL will only detect these corruption when it uses that heap or index page. So a safe way to is to dump/restore your database if you suspect there is some inconsistency happened. Regards, Qingqing
