Re: pg_restore fails

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Saturday, March 12, 2016, Karsten Hilbert <Karsten.Hilbert@xxxxxxx> 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.