Harry <postituk@yahoo.com> writes:
> Is there any material online on how to recover a corrupt postgresql
> database?
There are dozens if not hundreds of case histories in the mailing list
archives; the latest example is this thread:
http://archives.postgresql.org/pgsql-hackers/2004-12/msg00479.php
Feel free to try to pull something together from that info.
However, the rule of thumb is "every problem is different". If we could
think of a cookbook procedure then we'd build an automated recovery tool
... so you need to think more in terms of teaching than of giving
recipes.
regards, tom lane