Re: BUG #16147: postgresql 12.1 (from homebrew) - pg_restore -h localhost --jobs=2 crashes
PikachuEXE <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.bugs |
|---|---|
| Message-ID | <[email protected]> |
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