From: | "ascot(dot)moss(at)gmail(dot)com" <ascot(dot)moss(at)gmail(dot)com> |
---|---|
To: | Michael Paquier <michael(dot)paquier(at)gmail(dot)com> |
Cc: | "ascot(dot)moss(at)gmail(dot)com" <ascot(dot)moss(at)gmail(dot)com>, pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: Enable WAL Archive in Replication server |
Date: | 2013-08-12 11:18:14 |
Message-ID: | 6BC3020E-0A9B-4434-83A4-41E38E10CB25@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Thanks so much.
On 12 Aug 2013, at 6:45 AM, Michael Paquier wrote:
> On Mon, Aug 12, 2013 at 1:53 AM, ascot(dot)moss(at)gmail(dot)com
> <ascot(dot)moss(at)gmail(dot)com> wrote:
>> I want to enable WAL archive on the replica, I am advised that WAL archive
>> can only be enabled on the Master, can you please advise if this is a bug
>> and any workaround available?
> Archiving a WAL file is only done once its generation has been
> completed by a master server. A standby node only replays WAL files,
> copying them from the indicated archive folder with restore_command to
> its local pg_xlog folder when necessary, and performs no archive
> actions.
> http://www.postgresql.org/docs/devel/static/continuous-archiving.html#BACKUP-ARCHIVING-WAL
> --
> Michael
From | Date | Subject | |
---|---|---|---|
Next Message | Pavel Stehule | 2013-08-12 11:47:53 | Re: BUG #8329: UPDATE x SET x.y = x.y + z does not work in PL/pgSQL |
Previous Message | Pavel Raiskup | 2013-08-12 10:37:29 | [PATCH] Re: [BUGS] BUG #7815: Upgrading PostgreSQL from 9.1 to 9.2 with pg_upgrade/postgreql-setup fails - invalid status retrieve |