On Tue, Aug 23, 2011 at 7:17 PM, Ray Stell <ste...@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 Blog: http://raghavt.blogspot.com/
