On Mon, 12 Mar 2001, Scott Price wrote:
> To: Tom Lane, and Postgresql.org staff,
>
> This is a message in response to the one sent by Frank Miles on Tue 7 Nov 2000
>11:11:29 -0800 (PST).
>
> I have been experiencing the same problem as the gentleman, Frank Miles, when
>running Postgre SQL. I have been repeatedly getting "pqReadData - backend closed the
>channel unexpectedly. This probably means that .... the backend abruptly terminated
>before or while your request was being processed" (or something close to those
>words). The last response I saw from postgresql.org to Frank was from a fellow Tom
>Lane asking to see a core dump. Since I experienced this problem I would like to
>send you a core dump of my file (which is gzipped), core.gz, and if you all could
>give me any explanations or recommendations, I'd appreciate it.
>
> Postgre SQL Version 6.5.3 on i686-pc-linux-gnu, compiled by gcc egcs-2.91.66.
>
> My email: [EMAIL PROTECTED]
My dim recollection was that the underlying problem was that a table had been renamed
(bad order of operations!!), damaging one or more foreign key links. I was able to
fix it by editing a pg_dump'ed version of the database, and restoring the database
from the dump, thereby repairing the FK links.
Your problem may be different!
-frank
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
