Re: PostgreSQL 14: pg_dump / pg_restore error: could not write to the communication channel: Broken pipe - Mailing list pgsql-general

From Tom Lane
Subject Re: PostgreSQL 14: pg_dump / pg_restore error: could not write to the communication channel: Broken pipe
Date
Msg-id 963372.1634317694@sss.pgh.pa.us
Whole thread Raw
In response to Re: PostgreSQL 14: pg_dump / pg_restore error: could not write to the communication channel: Broken pipe  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Responses Re: PostgreSQL 14: pg_dump / pg_restore error: could not write to the communication channel: Broken pipe
List pgsql-general
Alvaro Herrera <alvherre@alvh.no-ip.org> writes:
> Yeah, pg_dump in parallel mode uses a pipe to communicate between leader
> and workers; the error you see is what happens when a write to the pipe
> fails.  It sounds to me like something in the operating system is
> preventing the pipes from working properly.

BTW, I think a more likely explanation is "one of the pg_dump or
pg_restore worker processes crashed".  Why that should be is still
a mystery though.

            regards, tom lane



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: PostgreSQL 14: pg_dump / pg_restore error: could not write to the communication channel: Broken pipe
Next
From: Seref Arikan
Date:
Subject: Stuck: how can I disable automatic json array unwrapping?