pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: PikachuEXE <pikachuexe@gmail.com>
To: pgsql-bugs@postgresql.org
Subject: Re: BUG #16147: postgresql 12.1 (from homebrew) - pg_restore -h localhost --jobs=2 crashes
Date: Mon, 9 Dec 2019 01:57:34 -0700 (MST)
Message-ID: <1575881854624-0.post@n3.nabble.com> (raw)
In-Reply-To: <16147-34dfe783aba141b0@postgresql.org>
References: <16147-34dfe783aba141b0@postgresql.org>

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
<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
<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
<https://github.com/PostgresApp/PostgresApp/issues/538;  



--
Sent from: https://www.postgresql-archive.org/PostgreSQL-bugs-f2117394.html





view thread (8+ messages)  latest in thread

Message-ID: <1575881854624-0.post@n3.nabble.com>
Permalink:  ../1575881854624-0.post@n3.nabble.com/
Also on:    postgresql.org/message-id/1575881854624-0.post@n3.nabble.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-bugs@postgresql.org
  Cc: pikachuexe@gmail.com
  Subject: Re: BUG #16147: postgresql 12.1 (from homebrew) - pg_restore -h localhost --jobs=2 crashes
  In-Reply-To: <1575881854624-0.post@n3.nabble.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox