Postgres Pro
Downloads
Home   >   mailing lists

[GENERAL] pg_restore successful with warnings returns exit code of non-zero - Mailing list pgsql-general

From dhanuj hippie
Subject [GENERAL] pg_restore successful with warnings returns exit code of non-zero
Date
Msg-id CAGqAkKcb+ccU1CgHburnbLN4qShW1-a-reN1oCoC5rMSQWKgZw@mail.gmail.com
Whole thread Raw
Responses Re: [GENERAL] pg_restore successful with warnings returns exit codeof non-zero  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Johann Spies
Date:
Subject: Re: [GENERAL] column "waiting" does not exist
Next
From: Adrian Klaver
Date:
Subject: Re: [GENERAL] pg_restore successful with warnings returns exit codeof non-zero