Re: Upgrade 96 -> 11

On 9/2/19 5:38 PM, James Sewell wrote:
>
>
> On Tue, 3 Sep 2019 at 10:34, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com
> <mailto:adrian(dot)klaver(at)aklaver(dot)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(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)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(dot)klaver(at)aklaver(dot)com