Re: [PG_UPGRADE] 9.6 to 10.5

2018-08-14 18:23 GMT-03:00 Bruce Momjian <bruce(at)momjian(dot)us>:
>
> 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.

I didn't want to jump in earlier as I'm not a pg_upgrade expert, and
to be honest, haven't done any code reading around this tool, but I
was puzzled with Michael's comment on pg_upgrade failing on a standby
node. I have always been under the impression that pg_upgrade had to
be executed on a primary server, and standbys had to be recloned or
rsynced (which is just the old way of recloning).

Maybe there's something I wasn't aware of. But if that's the case,
then the docs don't reflect this missing knowledge and we should amend
it.

Regards,

--
Martín Marqués http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services