From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | James Sewell <james(dot)sewell(at)jirotech(dot)com> |
Cc: | "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Upgrade 96 -> 11 |
Date: | 2019-09-03 00:52:34 |
Message-ID: | 8e2ba725-44aa-9ecc-c296-762a14107af3@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Matthias Apitz | 2019-09-03 07:56:42 | restore and recovery using WAL: unkown messages in serverlog |
Previous Message | James Sewell | 2019-09-03 00:38:10 | Re: Upgrade 96 -> 11 |