[GENERAL] Wal archiving and streaming replication

2011-08-23 Thread alexondi
Hi! Do I need setup wal archiving (archiving_mode = on) setup when I use streaming replication? -- View this message in context: http://postgresql.1045698.n5.nabble.com/Wal-archiving-and-streaming-replication-tp4726040p4726040.html Sent from the PostgreSQL - general mailing list archive at

Re: [GENERAL] Wal archiving and streaming replication

2011-08-23 Thread Ray Stell
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 -- Sent via pgsql-general mailing list

Re: [GENERAL] Wal archiving and streaming replication

2011-08-23 Thread Adrian Klaver
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

Re: [GENERAL] Wal archiving and streaming replication

2011-08-23 Thread Ray Stell
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

Re: [GENERAL] Wal archiving and streaming replication

2011-08-23 Thread Raghavendra
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

Re: [GENERAL] Wal archiving and streaming replication

2011-08-23 Thread Ray Stell
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

Re: [GENERAL] Wal archiving and streaming replication

2011-08-23 Thread Raghavendra
On Tue, Aug 23, 2011 at 10:49 PM, Ray Stell ste...@cns.vt.edu wrote: 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