Re: pg_upgrade and rsync

On Fri, Mar 6, 2015 at 12:19:36PM -0500, Bruce Momjian wrote:
> On Fri, Mar 6, 2015 at 10:50:27AM +0300, Vladimir Borodin wrote:
> > What I have done is to update the pg_upgrade instructions to add this
> > required step. Updated doc patch attached. (I also added the --delete
> > flag to rsync.) Thanks so much for your detailed report.
> >
> >
> > It seems to work fine now. The only thing that would be nice to change is
> > to explicitly write that these instructions are correct for hot standby
> > installations too.
> >
> > + <para>
> > + If you have Log-Shipping Standby Servers (<xref
> > + linkend="warm-standby">), follow these steps to upgrade them (before
> > + starting any servers):
> > + </para>
> >
> > Actually, I’ve entered this thread because it is not obvious from the paragraph
> > above or any other places.
>
> Oh, very good point. I was trying to match the wording we use in the
> docs, but forgot that log shipping and streaming replication are
> specified separately.
>
> Updated patch attached. You can view the output at:
>
> http://momjian.us/tmp/pgsql/pgupgrade.html
>
> Thanks much!

Patch applied to head. While it will work all the way back to 9.0, the
instructions need a shaking out during beta. I will blog that people
can try it. Thanks to Stephen Frost for coming up with this solution.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ Everyone has their own god. +