On Tue, Aug 23, 2011 at 7:17 PM, Ray Stell <stellr@xxxxxxxxxx> wrote:
On Tue, Aug 23, 2011 at 06:23:58AM -0700, Adrian Klaver wrote:right, you don't need to. I find it to be a best practice, which is different.
> 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
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
