Re: error in postgresql

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