Re: pg_upgrade failure due to dependencies

Nikhil Shetty <nikhil.dba04@gmail.com> writes:
> Yes both the extension and function are created by the extension but when
> restoring, extension and associated functions or tables are created
> separately and in different order .

Ah, right, I'd momentarily forgotten that binary-upgrade mode dumps
the extensions' contents as separate objects.

I think that switching the function(s) to new-style syntax, as already
mentioned, might get you pretty far.  It'd be enough for pg_dump to get
the function-vs-spatial_ref_sys-existence ordering right at least.
What it will not do is ensure that the *contents* of spatial_ref_sys
are restored early.  But I'm not sure that that's fatal in a
binary-upgrade situation, because we're not dumping/restoring data:
the tables' disk files are just moved verbatim.  There might still be
some edge cases that fail, but I think basic scenarios ought to work.

            regards, tom lane