On Wed, Nov 7, 2012 at 5:59 PM, Bruce Momjian <bruce@momjian.us> wrote:
>> > 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.
I guess it depends on the release (ie: whether a table rewrite is necessary).
I'll check next time I upgrade a database, but I don't expect it to be
anytime soon.