Horton

Re: pg_restore crash when there is a failure before all child process is created

vignesh C <vignesh21@gmail.com>

View thread View on postgr.es
From: vignesh C <vignesh21@gmail.com>
To: Ahsan Hadi <ahsan.hadi@gmail.com>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2020-01-30T04:24:17Z
Lists: pgsql-hackers 
On Wed, Jan 29, 2020 at 6:54 PM Ahsan Hadi <ahsan.hadi@gmail.com> wrote:
>
> Hi Vignesh,
>
> Can you share a test case or steps that you are using to reproduce this issue? Are you reproducing this using a debugger?
>

I could reproduce with the following steps:
Make cluster setup.
Create few tables.
Take a dump in directory format using pg_dump.
Restore the dump generated above using pg_restore with very high
number for --jobs options around 600.

Regards,
Vignesh
EnterpriseDB: http://www.enterprisedb.com

Commits

  1. Fix parallel pg_dump/pg_restore for failure to create worker processes.