Postgres Pro
Downloads
Home   >   mailing lists

Re: Wal archiving and streaming replication - Mailing list pgsql-general

From Raghavendra
Subject Re: Wal archiving and streaming replication
Date
Msg-id CA+h6AhiG+kS7wa07owgcbiuKX_7AiOkmg8A3+9uhh4j22T9B4g@mail.gmail.com
Whole thread Raw
In response to Re: Wal archiving and streaming replication  (Ray Stell <stellr@cns.vt.edu>)
Responses Re: Wal archiving and streaming replication  (Ray Stell <stellr@cns.vt.edu>)
List pgsql-general
Tree view
On Tue, Aug 23, 2011 at 7:17 PM, Ray Stell <stellr@cns.vt.edu> wrote:
On Tue, Aug 23, 2011 at 06:23:58AM -0700, Adrian Klaver wrote:
> On Tuesday, August 23, 2011 4:14:15 am Ray Stell wrote:
> > On Tue, Aug 23, 2011 at 02:01:10AM -0700, alexondi wrote:
> > > Hi!
> > > Do I need setup wal archiving (archiving_mode = on) setup when I  use
> > > streaming replication?
> >
> > yes
> > http://www.postgresql.org/docs/current/interactive/high-availability.html
>
> Actually no. Streaming will work without archiving. For a quick introduction
> see:
>
> http://wiki.postgresql.org/wiki/Binary_Replication_Tutorial#5_Minutes_to_Simple_Replication

right, you don't need to.  I find it to be a best practice, which is different.


Question:

Is it a best practice to keep cluster in Archive_mode = on and setup streaming replication or just leave archive_mode=off? 

---
Regards,
Raghavendra
EnterpriseDB Corporation


pgsql-general by date:

Previous
From: Vincent Veyron
Date:
Subject: Re: COPY FROM (query) in plpgsql
Next
From: f vf
Date:
Subject: Executing more than one function.