Re: Do I need archive_mode = on for hot standby? - Mailing list pgsql-general

From Andy Chambers
Subject Re: Do I need archive_mode = on for hot standby?
Date
Msg-id CAAfW55r-5=Wk-VEXkMJXsWtPrLZueZkfgV+9xZNPviqsj=jixw@mail.gmail.com
Whole thread Raw
In response to Do I need archive_mode = on for hot standby?  (Janne H <jannehson51@yahoo.com>)
List pgsql-general
On Mon, Jul 2, 2012 at 3:33 AM, Janne H <jannehson51@yahoo.com> wrote:
Hi there.

I'm planning on setting up a master database and multiple hot standby slaves using streaming replication.

If I use a large(*) value on
wal_keep_segments
do I really need archive_mode = on then?

Any potential problems with this strategy I should be aware about?

(*) With large value I mean a value such that a failed slave will be up and running again (with a few days margin) before the master server starts to clean out old WAL segments.

I believe you are correct.  At least that's what it says here...


--
Andy

pgsql-general by date:

Previous
From: Andy Chambers
Date:
Subject: Sequence moves forward when failover is triggerred
Next
From: Tom Lane
Date:
Subject: Re: Sequence moves forward when failover is triggerred