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
Список
Дерево обсуждения
data loss with pg_standby when doing a controlled failover Andreas Pflug <pgadmin@pse-consulting.de>
Re: data loss with pg_standby when doing a controlled failover Guillaume Smet <guillaume.smet@gmail.com>
Re: data loss with pg_standby when doing a controlled failover Andreas Pflug <pgadmin@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 Andreas Pflug <pgadmin@pse-consulting.de>
Re: data loss with pg_standby when doing a controlled failover Fujii Masao <masao.fujii@gmail.com>
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 по дате отправления
От: Scott Mead
Дата: