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.