Re: pg_restore fails

On Saturday, March 12, 2016, Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net>
wrote:

> On Sat, Mar 12, 2016 at 05:49:56PM -0700, David G. Johnston wrote:
>
> > I'd operate under the premise that all warnings and errors are fatal
> > (i.e., keep --exit-on-error) until you cannot for some very specific
> > reason.
>
> --exit-on-error will exit on _any_ perceived error,
> regardless of whether it could be ignored and the restore
> still succeed later on. Hence I cannot keep that option in
> use in order to implement the below.
>
> The unfortunate thing is that *any* restore will "fail"
> because the schema PUBLIC is copied from the template and
> that alone will produce an (ignorable) error...
>
>
So you make things so that error doesn't occur, the work-arounds are
reasonably simple.

Using either clean or create alone succeeded without the public schema
error. It is only when you use both will it fail. But both those
individual options have pre-reqs you need to ensure are met before calling
pg_restore.

David J.