Re: Enable WAL Archive in Replication server

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

In response to

Browse pgsql-bugs by date

  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