Re: Using pg_upgrade on log-shipping standby servers
Bruce Momjian <bruce@momjian.us>
From: Bruce Momjian <bruce@momjian.us>
To: Magnus Hagander <magnus@hagander.net>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2012-07-10T17:27:27Z
Lists: pgsql-hackers
Attachments
- pg_upgrade.diff (text/x-diff) patch
On Tue, Jul 10, 2012 at 07:06:39PM +0200, Magnus Hagander wrote: > >> >> 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. > > > > I went the other direction and just said you can't upgrade a standby (as > > a standby), and to just use rsync --- patch attached. > > Reads much better now. I'd say "use rsync to rebuild the standbys", > but that's more nitpicking :) (And maybe "the simplest way" rather > than "the simplest case"? But i'll leave that to someone who has > english as their first language) Both change made; updated patch attached. -- Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. +