Re: Wal archiving and streaming replication

From: Ray Stell <stellr(at)cns(dot)vt(dot)edu>
To: Raghavendra <raghavendra(dot)rao(at)enterprisedb(dot)com>
Cc: Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org, alexondi <alexondi(at)rambler(dot)ru>
Subject: Re: Wal archiving and streaming replication
Date: 2011-08-23 17:19:59
Message-ID: 20110823171959.GB13220@cns.vt.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David Johnston 2011-08-23 21:36:56 View "Caching" - Is this Known and Expected Behavior?
Previous Message Giuseppe Sacco 2011-08-23 16:42:29 Re: Executing more than one function.