Streaming replication document - Mailing list pgsql-hackers

From Tatsuo Ishii
Subject Streaming replication document
Date
Msg-id 20101204.111820.60332142212192675.t-ishii@sraoss.co.jp
Whole thread Raw
Responses Re: Streaming replication document  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
List pgsql-hackers
Hi,

There is a description about streaming replication in the doc:
----------------------------------------------------------
25.2.5. Streaming Replication

:
:
If you set up a WAL archive that's accessible from the
standby, wal_keep_segments is not required as the standby can always
use the archive to catch up.
----------------------------------------------------------

I think this description is somewhat inadequate. Since recovery using
WAL archive is file based, it may cause long replication delay. I
think even if WAL archive is set up, we should set wal_keep_segments
to proper value, not 0. Recovery from WAL archive should be the last
resort, shouldn't be?
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp


pgsql-hackers by date:

Previous
From: "David E. Wheeler"
Date:
Subject: Review: Extensions Patch
Next
From: MARK CALLAGHAN
Date:
Subject: Re: We need index-only scans