On Mon, Apr 9, 2012 at 7:33 PM, 乔志强 <qiaozhiqiang@leadcoretech.com> wrote:
> Question:
> Why the master deletes the WAL segment before send to standby in synchronous mode?
Otherwise the master might be filled up with lots of unsent WAL files and
which might cause PANIC error in the master, when there is no standby.
IOW, the master tries to avoid a PANIC error rather than termination of
replication.
> It is a streaming replication bug ?
No. It's intentional.
> If use synchronous_standby_names for sync standby, if no online standby, all commit will delay to standby connect to
master,
> So wal_keep_segments is only for offline async standby actually.
What if synchronous_commit is set to local or async?
Regards,
--
Fujii Masao