Re: pg_restore fails

On Sun, Mar 13, 2016 at 12:37:02AM +0100, Karsten Hilbert wrote:

> > > pg_restore: [Archivierer (DB)] Fehler in Phase PROCESSING TOC:
> > > pg_restore: [Archivierer (DB)] Fehler in Inhaltsverzeichniseintrag 8; 2615 2200 SCHEMA public postgres
> > > pg_restore: [Archivierer (DB)] could not execute query: FEHLER: Schema „public“ existiert bereits
> > > Die Anweisung war: CREATE SCHEMA public;
> > >
> > >I am sure I am doing something wrong, but what ?
> >
> > Did it actually fail or did it just throw an error?
> > In other words did the restore continue past the error?
>
> Good question. I'll remove the --exit-on-error and retry :-)

It actually went through with the last line saying

WARNING: 1 error during restor was ignored

pg_restore does not return exit code 0 anymore, however, and
offhand I can't find documentation as to whether pg_restore
returns different error codes between success and
success-with-ignored-errors. It does not seem to return 0
when it "ignores" errors.

Karsten
--
GPG key ID E4071346 @ eu.pool.sks-keyservers.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346