BUG #16147: postgresql 12.1 (from homebrew) - pg_restore -h localhost --jobs=2 crashes - Mailing list pgsql-bugs

From PG Bug reporting form
Subject BUG #16147: postgresql 12.1 (from homebrew) - pg_restore -h localhost --jobs=2 crashes
Date
Msg-id 16147-34dfe783aba141b0@postgresql.org
Whole thread Raw
Responses Re: BUG #16147: postgresql 12.1 (from homebrew) - pg_restore -h localhost --jobs=2 crashes
Re: BUG #16147: postgresql 12.1 (from homebrew) - pg_restore -hlocalhost --jobs=2 crashes
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      16147
Logged by:          Bill Tihen
Email address:      btihen@gmail.com
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.


pgsql-bugs by date:

Previous
From: Marco Cuccato
Date:
Subject: Re: LDAPS trusted ca support
Next
From: Tom Lane
Date:
Subject: Re: BUG #16145: Not able to terminate active session