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

From: Eduardo Morras <emorrasg(at)yahoo(dot)es>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: HOT Standby - slave does not appear to be removing wal files
Date: 2013-03-07 10:18:34
Message-ID: 20130307111834.5fbda1de419a5f042c13f5b7@yahoo.es
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Wed, 06 Mar 2013 19:09:43 -0700
CS DBA <cs_dba(at)consistentstate(dot)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 the slave must store all wal files to be able to undo the big dump transaction.

--- ---
Eduardo Morras <emorrasg(at)yahoo(dot)es>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jorge Torralba 2013-03-13 01:28:39 Corruption with PITR restore
Previous Message CS DBA 2013-03-07 02:09:43 Re: HOT Standby - slave does not appear to be removing wal files