Re: [GENERAL] pg_restore successful with warnings returns exit codeof non-zero - Mailing list pgsql-general

From Adrian Klaver
Subject Re: [GENERAL] pg_restore successful with warnings returns exit codeof non-zero
Date
Msg-id 0365f02e-fe53-f888-5659-662f168baf52@aklaver.com
Whole thread Raw
In response to [GENERAL] pg_restore successful with warnings returns exit code of non-zero  (dhanuj hippie <dhanuj.hippie@gmail.com>)
List pgsql-general
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


pgsql-general by date:

Previous
From: dhanuj hippie
Date:
Subject: [GENERAL] pg_restore successful with warnings returns exit code of non-zero
Next
From: Dave Quello
Date:
Subject: [GENERAL] Postgres 9.x table/index stats reset timestamp