| From: | Michael Paquier <michael(dot)paquier(at)gmail(dot)com> |
|---|---|
| To: | James Sewell <james(dot)sewell(at)lisasoft(dot)com> |
| Cc: | Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: WAL archive on slave |
| Date: | 2014-02-10 02:49:15 |
| Message-ID: | CAB7nPqTzZMQExs2QcooR7_FYF0grJT8eYvh5hn+D09JM9Jo-dg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, Feb 10, 2014 at 9:43 AM, James Sewell <james(dot)sewell(at)lisasoft(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Paquier | 2014-02-10 02:52:02 | Re: Better Connection Statistics |
| Previous Message | James Sewell | 2014-02-10 00:43:03 | Re: WAL archive on slave |