Re: Upgrade 96 -> 11

On 9/3/19 3:45 PM, James Sewell wrote:
>
>

>
> -- For binary upgrade, create an empty extension and insert objects
> into it
> DROP EXTENSION IF EXISTS tablefunc;
> SELECT pg_catalog.binary_upgrade_create_empty_extension('tablefunc',
> 'public', true, '1.0', NULL, NULL, ARRAY[]::pg_catalog.text[]);
>
>
> Try the above on your schema and see what you get.
>
>
> Yep - an empty extension. I think this logic is wrong. Creating an empty
> extension is fine and makes sense but extension owned relations should
> be created as the next step, not just at some time later.
>

So to be clear you ran pg_dump with --binary-upgrade and the extension
elements where created after the user table that tripped the error?

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com