Postgres Pro
Downloads
Home   >   mailing lists

Re: WAL archive on slave - Mailing list pgsql-general

From Michael Paquier
Subject Re: WAL archive on slave
Date
Msg-id CAB7nPqTzZMQExs2QcooR7_FYF0grJT8eYvh5hn+D09JM9Jo-dg@mail.gmail.com
Whole thread Raw
In response to Re: WAL archive on slave  (James Sewell <james.sewell@lisasoft.com>)
List pgsql-general
Tree view



On Mon, Feb 10, 2014 at 9:43 AM, James Sewell <james.sewell@lisasoft.com> wrote:
Hi again,

I just realised I asked this question around a year ago (for a different reason actually) and you answered me then! Amazing!

Your answer then was:

It works fine, only the server will not generate WAL while 
it is in recovery.  As soon as you promote the standby, 
it will archive ist WALs. 

Is this still correct?
Yes, it is. A slave will begin to archive WALs after getting promoted and dumping to a new timeline.
 
I'm still not sure why they wouldn't be archived on the slave, seen as they show up in the directory?
WAL files are only replayed on a slave, not archived.
Regards
--
Michael

pgsql-general by date:

Previous
From: James Sewell
Date:
Subject: Re: WAL archive on slave
Next
From: Michael Paquier
Date:
Subject: Re: Better Connection Statistics