PostgreSQL Bugs

Collected from the PG bugs email list.

Bug ID16147
PG Version12.1
OSMacOS 10.15.1
Opened2019-12-04 11:46:35+00
Reported byBill Tihen
StatusNew

Body of first available message related to this bug follows.

The following bug has been logged on the website:

Bug reference:      16147
Logged by:          Bill Tihen
Email address:      (redacted)
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.

Messages

DateAuthorSubject
2019-12-04 11:46:35+00PG Bug reporting formBUG #16147: postgresql 12.1 (from homebrew) - pg_restore -h localhost --jobs=2 crashes
2019-12-04 14:03:26+00Tom LaneRe: BUG #16147: postgresql 12.1 (from homebrew) - pg_restore -h localhost --jobs=2 crashes
2019-12-09 08:57:34+00PikachuEXERe: BUG #16147: postgresql 12.1 (from homebrew) - pg_restore -h localhost --jobs=2 crashes
2020-02-18 07:23:46+00sailorRe: BUG #16147: postgresql 12.1 (from homebrew) - pg_restore -h localhost --jobs=2 crashes
2020-05-15 13:53:29+00David GilmanRe: BUG #16147: postgresql 12.1 (from homebrew) - pg_restore -h localhost --jobs=2 crashes
2020-05-20 00:52:25+00David GilmanRe: BUG #16147: postgresql 12.1 (from homebrew) - pg_restore -h localhost --jobs=2 crashes