Postgres Pro
Downloads
Home   >   mailing lists

Re: HOT Standby - slave does not appear to be removing wal files - Mailing list pgsql-admin

From Eduardo Morras
Subject Re: HOT Standby - slave does not appear to be removing wal files
Date
Msg-id 20130307111834.5fbda1de419a5f042c13f5b7@yahoo.es
Whole thread Raw
In response to Re: HOT Standby - slave does not appear to be removing wal files  (CS DBA <cs_dba@consistentstate.com>)
List pgsql-admin
Tree view 
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 by date:

Previous
From: CS DBA
Date:
Subject: Re: HOT Standby - slave does not appear to be removing wal files
Next
From: Jorge Torralba
Date:
Subject: Corruption with PITR restore