BUG #16147: postgresql 12.1 (from homebrew) - pg_restore -h localhost --jobs=2 crashes
PG Bug reporting form <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.bugs |
|---|---|
| Message-ID | <[email protected]> |
The following bug has been logged on the website: Bug reference: 16147 Logged by: Bill Tihen Email address: [email protected] PostgreSQL version: 12.1 Operating system: MacOS 10.15.1 Description: The following command crashes with any database I've tried (both large and small) DBs: `pg_restore -U wti0405 -d stage3 -h localhost --jobs=8 -Fc database_12_04-01-00.bak -x` I get the error others have associated with a locking problem in earlier versions: `pg_restore: error: a worker process died unexpectedly` Interesting both of the following commands work! `pg_restore -U wti0405 -d stage3 --jobs=8 -Fc database_12_04-01-00.bak -x` & `pg_restore -U wti0405 -d stage3 -h localhost -Fc database_12_04-01-00.bak -x` So it appears this is only a problem when using parallelization with a TCP and not a local socket.