Database is in recovery mode.

Hello,

I have a problem with client's database. When I log into application and
work on the data everything seems fine, but when I try to dumpd the
database connection closes. I have located the faulty table and when I try
to cluster it I get FATAL: database is in recovery mode. It seems that
there are some corrupted rows in the table but I can't find the way to
repai the table and therefore whole DB.
PG is in the version 8.2 (in 2 weeks we are migrating to 9.0 and we are
preparing our clients' DBs for the migration) running on Windows.
Any help will be useful with this issue.

The results of the pg_dump of the broken table:
pg_dump: Dumping the contents of table "invoice" failed: PQgetCopyData()
failed.
pg_dump: Error message from server: server closed the connection
unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
pg_dump: The command was: COPY public.invoice(Inv_id, iss_date, pay_date,
comp_name)
pg_dump: *** aborted because of error

Regards
Luke
--
Łukasz Brodziak