Re: PostgreSQL 14: pg_dump / pg_restore error: could not write to the communication channel: Broken pipe

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
Cc: Nick Renders <postgres(at)arcict(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: PostgreSQL 14: pg_dump / pg_restore error: could not write to the communication channel: Broken pipe
Date: 2021-10-15 17:08:14
Message-ID: 963372.1634317694@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Seref Arikan 2021-10-15 17:50:49 Stuck: how can I disable automatic json array unwrapping?
Previous Message Tom Lane 2021-10-15 16:33:00 Re: PostgreSQL 14: pg_dump / pg_restore error: could not write to the communication channel: Broken pipe