Search Postgresql Archives

Re: Wal archiving and streaming replication

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




On Tue, Aug 23, 2011 at 10:49 PM, Ray Stell <stellr@xxxxxxxxxx> wrote:
On Tue, Aug 23, 2011 at 08:30:55PM +0530, Raghavendra wrote:
>
> Is it a best practice to keep cluster in Archive_mode = on and setup
> streaming replication or just leave archive_mode=off?

Depends.  The reason for creating WAL is in case they are needed for recovery.
In the event that the stby host goes down, if bringing it back into service
exceeds wal_keep_segments on the primary then you would need to rebuild
the standby.  This is a local decision and should be made based on business
rules.

Thanks Ray.

--Raghav

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux