Re: Upgrade 96 -> 11

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