Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux