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@xxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general