| From: | PG Bug reporting form <noreply(at)postgresql(dot)org> |
|---|---|
| To: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
| Cc: | btihen(at)gmail(dot)com |
| Subject: | BUG #16147: postgresql 12.1 (from homebrew) - pg_restore -h localhost --jobs=2 crashes |
| Date: | 2019-12-04 11:46:35 |
| Message-ID: | 16147-34dfe783aba141b0@postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-hackers |
The following bug has been logged on the website:
Bug reference: 16147
Logged by: Bill Tihen
Email address: btihen(at)gmail(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2019-12-04 13:10:12 | Re: BUG #16145: Not able to terminate active session |
| Previous Message | Marco Cuccato | 2019-12-04 10:18:27 | Re: LDAPS trusted ca support |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Gierth | 2019-12-04 11:49:20 | Re: Unsigned 64 bit integer to numeric |
| Previous Message | didier | 2019-12-04 11:42:30 | Re: Unsigned 64 bit integer to numeric |