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
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
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
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
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
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
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