On Wed, Nov 7, 2012 at 03:44:13PM -0300, Claudio Freire wrote: > On Wed, Nov 7, 2012 at 3:36 PM, Bruce Momjian <bruce@xxxxxxxxxx> wrote: > >> Bring both down. > >> pg_upgrade master > >> Bring master up > >> pg_upgrade slave > > > > Is there any reason to upgrade the slave when you are going to do rsync > > anyway? Of course you need to install the new binaries and libs, but it > > seems running pg_upgrade on the standby is unnecessary. > > Just to speed up the rsync pg_upgrade is mostly modifying the system tables --- not sure if that is faster than just having rsync copy those. The file modification times would be different after pg_upgrade, so rsync might copy the file anyway when you run pg_upgrade. It would be good for you to test if it really is a win --- I would be surprised if pg_upgrade was in this case on the standby. -- Bruce Momjian <bruce@xxxxxxxxxx> http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. + -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
