sharmad@goatelecom.com writes:
> postgres@linux:~ > pg_dumpall > alllms_30-10-2001.bak
> SQL query to dump the contents of Table 'common_to_three' did not execute. Explanation from backend: 'pqReadData()
--backend closed the channel unexpectedly.
> This probably means the backend terminated abnormally
> before or while processing the request.
> '.
> The query was: 'COPY "common_to_three" TO stdout;
Hm. The only cases I can recall of backend crashes during COPY OUT
were caused by corrupted data. Do you get similar failures if you
do "SELECT * FROM common_to_three"?
You could investigate more closely by using gdb to look at the core
file left by the crashed backend. A backtrace would give us at least
some idea of the nature of the problem.
regards, tom lane
