Do I need archive_mode = on for hot standby?

From: Janne H <jannehson51(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Do I need archive_mode = on for hot standby?
Date: 2012-07-02 07:33:04
Message-ID: 1341214384.21278.YahooMailClassic@web112812.mail.gq1.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message raghu ram 2012-07-02 08:32:10 Re: PostgreSQL Slony-I Replication
Previous Message Tom Lane 2012-07-02 04:54:40 Re: difference between implicit/explicit cast of integer to interval