Chris Purcell <[EMAIL PROTECTED]> writes: > Given that we are where we are, what is the best advice? Can we > recover the database, given that 99% of the data works? I can happily > drop the entire contents of the "pagecache" table, as it is > regenerated on the fly, if that will obviate the problem.
That will get you past the reported problem, but I wonder what other corruption is lurking ... once you've managed to pg_dump you'd better inspect the data very carefully. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org