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@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + Everyone has their own god. +