I'll try to get the primary upgraded over the weekend when we can afford a restart.
In the meantime I have a single test showing that a shutdown, snapshot, restart produces a backup that passes the vacuum analyze test. I'm going to run a full vacuum today. -David On Wed, May 15, 2013 at 3:53 PM, Heikki Linnakangas <hlinnakan...@vmware.com > wrote: > On 15.05.2013 22:50, Benedikt Grundmann wrote: > >> On Wed, May 15, 2013 at 2:50 PM, Heikki Linnakangas<hlinnakangas@** >> vmware.com <hlinnakan...@vmware.com> >> >>> The subject says 9.2.3. Are you sure you're running 9.2.4 on all the >>> >>> servers? There was a fix to a bug related to starting a standby server >>> from >>> a filesystem snapshot. I don't think it was quite the case you have, but >>> pretty close. >>> >> >> So this is delightfully embarrassing I just went back to double check and >> >> - primary box is 9.2.3 >> - standby is 9.2.4 >> - testing is 9.2.4 >> >> I guess that alone could possibly explain it? >> > > Hmm, no, it should still work. There haven't been any changes in the WAL > format. I do recommend upgrading the primary, of course, but I don't really > see how that would explain what you're seeing. > > - Heikki >
