| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | dhanuj hippie <dhanuj(dot)hippie(at)gmail(dot)com>, PostgreSQL mailing lists <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: pg_restore successful with warnings returns exit code of non-zero |
| Date: | 2017-03-02 16:06:57 |
| Message-ID: | 0365f02e-fe53-f888-5659-662f168baf52@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Quello | 2017-03-02 18:03:05 | Postgres 9.x table/index stats reset timestamp |
| Previous Message | dhanuj hippie | 2017-03-02 15:39:35 | pg_restore successful with warnings returns exit code of non-zero |