Thread: [GENERAL] pg_restore successful with warnings returns exit code of non-zero
[GENERAL] pg_restore successful with warnings returns exit code of non-zero
From
dhanuj hippie
Date:
I have a pg dump (custom format, column-inserts) which I'm restoring on an existing DB as
" /usr/bin/pg_restore -a -v -d db1 -F c " and the input is passed in from stdin. It warns on a couple of existing rows, but completes successfully with "WARNING: errors ignored on restore: 5".
However, this returns a exit code of 1 eventhough the command is run fine and data is restored. Is there a way to tell pg_restore to return 0 in this case ?
Thanks
Re: [GENERAL] pg_restore successful with warnings returns exit codeof non-zero
From
Adrian Klaver
Date:
On 03/02/2017 07:39 AM, dhanuj hippie wrote: > I have a pg dump (custom format, column-inserts) which I'm restoring on > an existing DB as > " /usr/bin/pg_restore -a -v -d db1 -F c " and the input is passed in > from stdin. It warns on a couple of existing rows, but completes > successfully with "WARNING: errors ignored on restore: 5". > However, this returns a exit code of 1 eventhough the command is run > fine and data is restored. Is there a way to tell pg_restore to return 0 > in this case ? Actually the command did not run fine, it threw 5 errors. Now they maybe harmless errors or they may not be, that should be for the user to determine after examining them. > > Thanks -- Adrian Klaver adrian.klaver@aklaver.com