Re: streaming replication, "frozen snapshot backup on it" and missing relfile (postgres 9.2.3 on xfs + LVM)
| От | David Powers |
|---|---|
| Тема | Re: streaming replication, "frozen snapshot backup on it" and missing relfile (postgres 9.2.3 on xfs + LVM) |
| Дата | |
| Msg-id | CAJpcCMi6dYXFheP6pwNUXffDzOhknW_ndK=aD+9dc2SvuhJuQA@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: streaming replication, "frozen snapshot backup on it" and missing relfile (postgres 9.2.3 on xfs + LVM) (Heikki Linnakangas <hlinnakangas@vmware.com>) |
| Ответы |
Re: streaming replication, "frozen snapshot backup on it"
and missing relfile (postgres 9.2.3 on xfs + LVM)
|
| Список | pgsql-hackers |
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@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.comThe 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
В списке pgsql-hackers по дате отправления: