"Florian Weimer" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
