Re: streaming replication, "frozen snapshot backup on it" and missing relfile (postgres 9.2.3 on xfs + LVM)

On 15.05.2013 22:50, Benedikt Grundmann wrote:
> On Wed, May 15, 2013 at 2:50 PM, Heikki Linnakangas<hlinnakangas@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