Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ieErL-0000BZ-IL for pgsql-bugs@arkaria.postgresql.org; Mon, 09 Dec 2019 08:57:39 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1ieErK-0001Zt-3Y for pgsql-bugs@arkaria.postgresql.org; Mon, 09 Dec 2019 08:57:38 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ieErJ-0001Zm-Nx for pgsql-bugs@lists.postgresql.org; Mon, 09 Dec 2019 08:57:37 +0000 Received: from n3.nabble.com ([162.255.23.22]) by makus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ieErH-0003jn-Au for pgsql-bugs@postgresql.org; Mon, 09 Dec 2019 08:57:36 +0000 Received: from n3.nabble.com (localhost [127.0.0.1]) by n3.nabble.com (Postfix) with ESMTP id A5440194CC5D9 for ; Mon, 9 Dec 2019 01:57:34 -0700 (MST) Date: Mon, 9 Dec 2019 01:57:34 -0700 (MST) From: PikachuEXE To: pgsql-bugs@postgresql.org Message-ID: <1575881854624-0.post@n3.nabble.com> In-Reply-To: <16147-34dfe783aba141b0@postgresql.org> References: <16147-34dfe783aba141b0@postgresql.org> Subject: Re: BUG #16147: postgresql 12.1 (from homebrew) - pg_restore -h localhost --jobs=2 crashes MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk I encounter similar issue with the following differences to OP - Operating system: MacOS 10.14.6 - PostgreSQL (both server & pg_restore) installed via PSQL.app https://github.com/PostgresApp/PostgresApp/releases/tag/v2.3.2 pg_restore's path is /Applications/Postgres.app/Contents/Versions/latest/bin/pg_restore Same as OP If the number of jobs is 1 or setting host to unix socket The error "pg_restore: error: a worker process died unexpectedly" won't be raised However this error doesn't happen on Ubuntu 18.04 version of psql ( https://www.ubuntuupdates.org/package/postgresql/bionic-pgdg/main/base/postgresql-12 ) So it might or might not be build issue for MacOS version Though having the same issue on both distribution channels (homebrew & psql.app) seem rare Anyway reported also to psql.app too https://github.com/PostgresApp/PostgresApp/issues/538 -- Sent from: https://www.postgresql-archive.org/PostgreSQL-bugs-f2117394.html