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

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 <hlinnakangas(at)vmware(dot)com
> wrote:

> On 15.05.2013 22:50, Benedikt Grundmann wrote:
>
>> On Wed, May 15, 2013 at 2:50 PM, Heikki Linnakangas<hlinnakangas(at)**
>> vmware.com <hlinnakangas(at)vmware(dot)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
>