On Thu, Jul 26, 2012 at 02:26:16PM -0700, Jeff Davis wrote:
> On Thu, 2012-07-26 at 14:17 -0400, Bruce Momjian wrote:
> > Yes, that would be a problem because the WAL records are deleted by
> > pg_upgrade. Does a shutdown of the standby not already replay all WAL
> > logs?
>
> There is no notion of "all WAL logs" because the WAL is infinite. Do you
> mean "all WAL generated by the master before shutdown" or "all WAL that
> the standby knows has been generated by the master so far"?
>
> Regardless, I don't think the standby attempts to do much after a
> shutdown is requested.
Doesn't matter anymore --- I now know pg_upgrade has to be run on the
standby, and it will be in primary mode and do full WAL reading before
it starts.
-- Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB
http://enterprisedb.com
+ It's impossible for everything to be true. +