From: | Maciek Sakrejda <m(dot)sakrejda(at)gmail(dot)com> |
---|---|
To: | Nick Renders <postgres(at)arcict(dot)com> |
Cc: | "pgsql-generallists(dot)postgresql(dot)org" <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 12:53:27 |
Message-ID: | CAOtHd0A597Ui3w4ViJaoY88A0k4k+PvcYQTA1bSJ9x4ebD4g_g@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Anything interesting in the Postgres server log when this happens?
On Fri, Oct 15, 2021, 05:21 Nick Renders <postgres(at)arcict(dot)com> wrote:
> Hello,
>
> I have been trying to import a Postgres 11 database into Postgres 14,
> but the pg_restore command exits with the following message:
>
> pg_restore: error: could not write to the communication channel:
> Broken
> pipe
>
> The command I sent looks like this:
>
> /Library/PostgreSQL/14/bin/pg_restore -h localhost -p 48100 -U
> postgres
> -w -C -d template1 -j 24 -Fd /Volumes/Migration/dbname --verbose
>
>
> It seems that the multiple jobs parameter is the cause. If I specify "-j
> 1", the command works without problems. If I specify "-j 2" or higher, I
> get the above error after a few seconds.
>
> Postgres is running on a Mac Pro 12-core machine, so it has plenty of
> resources at its disposal. The config file is a copy of the Postgres 11
> configuration, which has no problem with multiple jobs.
>
>
> Furthermore, the pg_dump command seems to have the same issue as well.
> The following command:
>
> /Library/PostgreSQL/14/bin/pg_dump -h localhost -p 48100 -U
> postgres -w
> ServicePGR_UTF8 -j 24 -Fd -f /Volumes/Migration/dbname --verbose
>
> will stop prematurely with the following error:
>
> pg_dump: error: could not write to the communication channel:
> Broken
> pipe
>
>
> Does this sound familiar to anyone? Is it an issue with the new Postgres
> 14 release, or is there something else that might be causing this?
>
> Best regards,
>
> Nick Renders
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2021-10-15 13:13:28 | Re: PostgreSQL 14: pg_dump / pg_restore error: could not write to the communication channel: Broken pipe |
Previous Message | Nick Renders | 2021-10-15 12:21:01 | PostgreSQL 14: pg_dump / pg_restore error: could not write to the communication channel: Broken pipe |