data loss with pg_standby when doing a controlled failover

Поиск
Список
Период
Сортировка
От Andreas Pflug
Тема data loss with pg_standby when doing a controlled failover
Дата
Msg-id 49D9E986.8010604@pse-consulting.de
обсуждение исходный текст
Ответы Re: data loss with pg_standby when doing a controlled failover  (Scott Mead <scott.lists@enterprisedb.com>)
Re: data loss with pg_standby when doing a controlled failover  (Guillaume Smet <guillaume.smet@gmail.com>)
Список pgsql-bugs
Running 8.3.7, I have a warm standby configuration with a
archive_timeout of 10min.

It's obvious that there's a 10min period where data could be lost if the
master fails and the warm standby server has to take over. What's not
obvious is that this is true even if the master server is shut down
regularly, because it will not write out a last log segment to the
archive. As a consequence, when doing a controlled failover (for
maintenance purposes or so) all data changed after the last archive copy
will be lost.
IMHO this should be mentioned in the docs explicitly (I find it quite
surprising that data can be lost even if the system is shutdown
correctly), or better when shutting down the postmaster should spit all
log segments containing all changes when archiving is on so the warm
standby server can catch up.

Regards.
Andreas

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Heikki Linnakangas
Дата:
Сообщение: Re: length() return wrong result
Следующее
От: Scott Mead
Дата:
Сообщение: Re: data loss with pg_standby when doing a controlled failover