Search Postgresql Archives

Re: Do I need archive_mode = on for hot standby?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Mon, Jul 2, 2012 at 3:33 AM, Janne H <jannehson51@xxxxxxxxx> 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...

http://wiki.postgresql.org/wiki/Streaming_Replication

--
Andy

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux