Re: [9.3 bug] disk space in pg_xlog increases during archive recovery

Поиск
Список
Период
Сортировка
Искать
От
MauMau
Тема
Re: [9.3 bug] disk space in pg_xlog increases during archive recovery
Дата
Msg-id
D924375477D34942A6B421B5B82123E7@maumau
Ответ на
Список
Дерево обсуждения
[9.3 bug] disk space in pg_xlog increases during archive recovery "MauMau" <maumau307@gmail.com>
Re: [9.3 bug] disk space in pg_xlog increases during archive recovery Fujii Masao <masao.fujii@gmail.com>
Re: [9.3 bug] disk space in pg_xlog increases during archive recovery "MauMau" <maumau307@gmail.com>
Re: [9.3 bug] disk space in pg_xlog increases during archive recovery Fujii Masao <masao.fujii@gmail.com>
Re: [9.3 bug] disk space in pg_xlog increases during archive recovery "MauMau" <maumau307@gmail.com>
Re: [9.3 bug] disk space in pg_xlog increases during archive recovery Fujii Masao <masao.fujii@gmail.com>
Re: [9.3 bug] disk space in pg_xlog increases during archive recovery "MauMau" <maumau307@gmail.com>
Re: [9.3 bug] disk space in pg_xlog increases during archive recovery Michael Paquier <michael.paquier@gmail.com>
Re: [9.3 bug] disk space in pg_xlog increases during archive recovery Fujii Masao <masao.fujii@gmail.com>
Re: [9.3 bug] disk space in pg_xlog increases during archive recovery Dimitri Fontaine <dimitri@2ndQuadrant.fr>
Re: [9.3 bug] disk space in pg_xlog increases during archive recovery Fujii Masao <masao.fujii@gmail.com>
Re: [9.3 bug] disk space in pg_xlog increases during archive recovery Jeff Janes <jeff.janes@gmail.com>
Re: [9.3 bug] disk space in pg_xlog increases during archive recovery "MauMau" <maumau307@gmail.com>
Re: [9.3 bug] disk space in pg_xlog increases during archive recovery Fujii Masao <masao.fujii@gmail.com>
Re: [9.3 bug] disk space in pg_xlog increases during archive recovery "MauMau" <maumau307@gmail.com>
Re: [9.3 bug] disk space in pg_xlog increases during archive recovery Fujii Masao <masao.fujii@gmail.com>
Re: [9.3 bug] disk space in pg_xlog increases during archive recovery Heikki Linnakangas <hlinnakangas@vmware.com>
Re: [9.3 bug] disk space in pg_xlog increases during archive recovery Andres Freund <andres@2ndquadrant.com>
Re: [9.3 bug] disk space in pg_xlog increases during archive recovery Fujii Masao <masao.fujii@gmail.com>
Re: [9.3 bug] disk space in pg_xlog increases during archive recovery "MauMau" <maumau307@gmail.com>
Re: [9.3 bug] disk space in pg_xlog increases during archive recovery Andres Freund <andres@2ndquadrant.com>
Re: [9.3 bug] disk space in pg_xlog increases during archive recovery Fujii Masao <masao.fujii@gmail.com>
Re: [9.3 bug] disk space in pg_xlog increases during archive recovery Andres Freund <andres@2ndquadrant.com>
Re: [9.3 bug] disk space in pg_xlog increases during archive recovery "MauMau" <maumau307@gmail.com>
Re: [9.3 bug] disk space in pg_xlog increases during archive recovery Andres Freund <andres@2ndquadrant.com>
Re: [9.3 bug] disk space in pg_xlog increases during archive recovery Andres Freund <andres@2ndquadrant.com>
Re: [9.3 bug] disk space in pg_xlog increases during archive recovery "MauMau" <maumau307@gmail.com>
From: "Fujii Masao" 
> - if (source == XLOG_FROM_ARCHIVE)
> + if (source == XLOG_FROM_ARCHIVE &&
> + StandbyModeRequested && AllowCascadeReplication())
>
> I think that the condition of StandbyModeRequested should be removed
> because someone might want to set up the cascade standby from the standby
> of warm-standby configuration.

Fixed and attached the revised patch.

However, isn't StandbyRequested true (= standby_mode set to on) to enable 
warm standby?  I'm afraid people set max_wal_senders>0 and hot_standby=on 
even on the primary server to make the contents of postgresql.conf identical 
on both the primary and the standby for easier configuration.  If so, normal 
archive recovery (PITR, not the standby recovery) would face the original 
problem -- unnecessary WAL accumulation in pg_xlog/.  So I'm wonder if 
AllowCascadeReplication() is enough.

Please take either this patch or the previous one.

Regards
MauMau
В списке pgsql-hackers по дате отправления
От: Robert Lerche (rlerche)
Дата:
Сообщение: PostgreSQL and ASLR on Linux
От: David Fetter
Дата:
FAQ