sql mailing list
archives, but so far can find no solution that fits; for instance, I
cannot find any tables under pg_toast., so cannot use the thread at
http://archives.postgresql.org/pgsql-admin/2005-09/msg00057.php
Any help would be most appreciated!
Cheers,
Chris Purcell
-
"old image" - does that refer to something like an filesystem level
backup or the restoration of a former pg_dump generated backup ?
The former is generally NOT save (except if you followed the PITR-
advises in the docs or similiar) with a running postmaster ...
Ah. Yes, the former, as we did
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.
Would the best advice be to get a pg_dump, then drop the database
entirely and rebuild it?
Cheers,
Chris
-
Would the best advice be to get a pg_dump, then drop the database
entirely and rebuild it?
Definitely. It's entirely possible for pg_dump to dump successfully
from a database that still contains corruption. An example:
broken indexes on user tables. COPY just does a seqscan and never
looks
See REINDEX. But my point was that there may be undetected
corruption.
If I were you I'd not rely on REINDEX to prevent all problems.
Indeed; REINDEX neither detected nor fixed the corruption.
Thanks for all your help; we'll recreate the database as soon as we can.
Many tha
