Re: BUG #16147: postgresql 12.1 (from homebrew) - pg_restore -h localhost --jobs=2 crashes

From: sailor <pavlok(at)enapps(dot)co(dot)uk>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #16147: postgresql 12.1 (from homebrew) - pg_restore -h localhost --jobs=2 crashes
Date: 2020-02-18 07:23:46
Message-ID: 1582010626326-0.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

Hello,
It doesn't work for me also even on PG version 12.2

OS: Ubuntu 18.04.4 LTS
postgresql-12 12.2-1.pgdg18.04+1
amd64
pg_dump (PostgreSQL) 12.2 (Ubuntu 12.2-1.pgdg18.04+1)
pg_restore (PostgreSQL) 12.2 (Ubuntu 12.2-1.pgdg18.04+1)

pg_restore: error: could not find block ID 11550 in archive -- possibly due
to out-of-order restore request, which cannot be handled due to lack of data
offsets in archive
pg_restore: error: could not find block ID 11546 in archive -- possibly due
to out-of-order restore request, which cannot be handled due to lack of data
offsets in archive
pg_restore: error: a worker process died unexpectedly

However, it works with --jobs=1

--
Sent from: https://www.postgresql-archive.org/PostgreSQL-bugs-f2117394.html

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Fan Liu 2020-02-18 07:52:50 [Bus error] huge_pages default value (try) not fall back
Previous Message Laxminarayan, Sudhanva 2020-02-18 06:32:38 Not able to run query/scripts on our Postgre instance which is on cloud foundry

Browse pgsql-hackers by date

  From Date Subject
Next Message Fujii Masao 2020-02-18 07:42:48 Re: pg_stat_progress_basebackup - progress reporting for pg_basebackup, in the server side
Previous Message Ants Aasma 2020-02-18 07:13:45 Re: Parallel copy