Re: Upgrade 96 -> 11 - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Upgrade 96 -> 11
Date
Msg-id 8e2ba725-44aa-9ecc-c296-762a14107af3@aklaver.com
Whole thread Raw
In response to Re: Upgrade 96 -> 11  (James Sewell <james.sewell@jirotech.com>)
Responses Re: Upgrade 96 -> 11
List pgsql-general
On 9/2/19 5:38 PM, James Sewell wrote:
> 
> 
> On Tue, 3 Sep 2019 at 10:34, Adrian Klaver <adrian.klaver@aklaver.com 
> <mailto:adrian.klaver@aklaver.com>> wrote:
> 
>     On 9/2/19 5:20 PM, James Sewell wrote:
>      >
> 
>      >     What is the pg_upgrade command you are using?
>      >
>      >
>      > pg_upgrade --link --username postgres
> 
>     Where are you in being able to?:
>     https://www.postgresql.org/docs/11/pgupgrade.html
> 
>     16. Reverting to old cluster
> 
>     ...
> 
>     If the --link option was used, the data files might be shared between
>     the old and new cluster:
> 
> 
> 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.

> 
>      >
>      > I have set PGBINOLD, PGBINNEW, PGDATAOLD, PGDATANEW correctly.
>      >
>      >
>      >
> 
>     -- 
>     Adrian Klaver
>     adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
> 
> 
> ------------------------------------------------------------------------
> The contents of this email are confidential and may be subject to legal 
> or professional privilege and copyright. No representation is made that 
> this email is free of viruses or other defects. If you have received 
> this communication in error, you may not copy or distribute any part of 
> it or otherwise disclose its contents to anyone. Please advise the 
> sender of your incorrect receipt of this correspondence.


-- 
Adrian Klaver
adrian.klaver@aklaver.com



pgsql-general by date:

Previous
From: James Sewell
Date:
Subject: Re: Upgrade 96 -> 11
Next
From: Matthias Apitz
Date:
Subject: restore and recovery using WAL: unkown messages in serverlog