Re: HOT Standby - slave does not appear to be removing wal files

Поиск
Список
Период
Сортировка
От Eduardo Morras
Тема Re: HOT Standby - slave does not appear to be removing wal files
Дата
Msg-id 20130307111834.5fbda1de419a5f042c13f5b7@yahoo.es
обсуждение исходный текст
Ответ на Re: HOT Standby - slave does not appear to be removing wal files  (CS DBA <cs_dba@consistentstate.com>)
Список pgsql-admin
On Wed, 06 Mar 2013 19:09:43 -0700
CS DBA <cs_dba@consistentstate.com> wrote:
> We actually are in HOT standby mode, and it is working. However we are
> also migrating a second db from an older (8.4) server into this master
> so we did a dump (using the 9.2.2 pg_dump binary) from the 8.4 db and
> then restored it into our current 9.2 master

I don't know, but maybe the dump from 8.4 to your master is one big transaction that must be rolled by the slave. So
theslave must store all wal files to be able to undo the big dump transaction. 

---   ---
Eduardo Morras <emorrasg@yahoo.es>


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

Предыдущее
От: CS DBA
Дата:
Сообщение: Re: HOT Standby - slave does not appear to be removing wal files
Следующее
От: Jorge Torralba
Дата:
Сообщение: Corruption with PITR restore