From: | Bruce Momjian <bruce(at)momjian(dot)us> |
---|---|
To: | Martin Marques <martin(dot)marques(at)2ndquadrant(dot)com> |
Cc: | DEGLAVE Remi <remi(dot)deglave(at)lyreco(dot)com>, "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>, Michael Paquier <michael(dot)paquier(at)gmail(dot)com> |
Subject: | Re: [PG_UPGRADE] 9.6 to 10.5 |
Date: | 2018-08-14 21:23:35 |
Message-ID: | 20180814212335.GD23476@momjian.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
On Fri, Aug 10, 2018 at 05:41:14PM -0300, Martin Marques wrote:
> El 10/08/18 a las 13:12, Bruce Momjian escribió:
> > On Fri, Aug 10, 2018 at 12:51:29PM +0000, DEGLAVE Remi wrote:
> >> The source cluster was not shut down cleanly.
> >>
> >> Failure, exiting
> >>
> >> I tried to restart and shutdown clusters with another methods (-m options of
> >> pg_ctl, killing processes, …) still have the same issue.
> >
> > There is new code in PG 10.5 thta detects that the server is cleanly
> > shut down. You can no longer use '-m immediate' to shut down either
> > server, but 'smart' and 'fast' should be fine. Can you run
> > pg_controldata on each cluster before you run pg_upgrade to verify that
> > they say "Shutdown":
>
> He did mention trying to shutdown with different modes, and ended with
> the same result after pg_upgrade.
>
> I would recommend running pg_upgrade in verbose mode (add the -v option
> to the cmd), capture the output and open a thread in pgsql-general list
> (or send it back here for further review).
I have not seen any report from the original reporter so I have gone
ahead and committed the fix suggested by Michael Paquier.
This means that standby upgrades will fail in 10.5 until 10.6 is
released. Ugh! I guess users can upgrade to 10.4 and then do a minor
upgrade to 10.5 as a workaround.
--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ As you are, so once was I. As I am, so you will be. +
+ Ancient Roman grave inscription +
From | Date | Subject | |
---|---|---|---|
Next Message | PG Bug reporting form | 2018-08-14 22:16:30 | BUG #15326: keep getting "ERROR: type "earth" does not exist" while it does exist |
Previous Message | PG Bug reporting form | 2018-08-14 18:26:16 | BUG #15325: RHEL 6.10 exists, download.postgresql.org doesn't support it |