On 9/2/19 5:52 PM, Adrian Klaver wrote:
>> It's still creating the schema elements when it fails, it hasn't
>> started linking yet
>
> Alright at least you still a working 9.6 cluster .
>
> Not sure where to go from here. Like you I am not sure how it can CREATE
> EXTENSION and not actually follow through on that. Especially with no
> errors for that operation. I'm going to have to think on this. Hopefully
> someone else has an idea on this and can chime in.
Aah. I don't have postgis installed, still:
pg_dump --binary-upgrade -s -d production -U postgres >
production_binary.sql
-- 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.
>
>>
>> >
>> > I have set PGBINOLD, PGBINNEW, PGDATAOLD, PGDATANEW correctly.
>>
--
Adrian Klaver
adrian.klaver@aklaver.com