Re: Wal archiving and streaming replication

On Tue, Aug 23, 2011 at 7:17 PM, Ray Stell <stellr(at)cns(dot)vt(dot)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
Blog: http://raghavt.blogspot.com/