On Tue, Jul 10, 2012 at 6:26 PM, Bruce Momjian <br...@momjian.us> wrote:
> On Tue, Jul 10, 2012 at 06:21:35PM +0200, Magnus Hagander wrote:
>> On Tue, Jul 10, 2012 at 6:17 PM, Bruce Momjian <br...@momjian.us> wrote:
>> > On Tue, Jul 10, 2012 at 12:04:50PM -0400, Tom Lane wrote:
>> >> Bruce Momjian <br...@momjian.us> writes:
>> >> > +    While a Log-Shipping Standby Server (<xref 
>> >> > linkend="warm-standby">) can
>> >> > +    be upgraded, the server must be in changed to a primary server to 
>> >> > allow
>> >> > +    writes, and after the upgrade it cannot be reused as a standby 
>> >> > server.
>> >> > +    (Running <command>rsync</> after the upgrade allows reuse.)
>> >>
>> >> "in changed"?  This sentence makes no sense at all to me.
>> >
>> > Oops.  New wording attached with "in" removed:
>> >
>> >         the server must be changed to a primary server
>> Don't we normally talk about "must be promoted to a primary server",
>> not changed?
> OK, sure, updated patch attached.
>> And wouldn't it be good if it also mentions that another good option
>> is to just pg_upgrade the master and rebuild the standby? (Unless
>> that's already mentioned somewhere else).
> I assume they already realize they re-create the standbys.
>> What's the actual usecase for promoting the slave, upgrading it and
>> then *not* using it, which is what I think this paragraph suggests?
> Testing maybe?  I feel we have just avoided saying what you can and
> can't do with the standbys and pg_upgrade, so I think we have to state
> something.  If we just want to say "recreate", let's say that.

Well, the bottom line is we can'd do *anything* with a standby with pg_upgrade.

Once you've promoted it, it is no longer a standby, and now you can
use pg_upgrade.

>> And I think the sentence about running rsync is extremely vague - run
>> rsync where and how? What are you actually trying to suggest people
>> do?
> Updated docs attached.

I suggest just removing the rsync part completely. You're basically
saying "you ca nset up a new standby after you're done", which is kind
of obvious anyway. And if you're going to use rsync fromthe master to
make a new standby, there's no point in running pg_upgrade on the new
standby in the first place.

 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/

Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:

Reply via email to