Re: [streaming replication] 9.1.3 streaming replication bug ? - Mailing list pgsql-general

From Fujii Masao
Subject Re: [streaming replication] 9.1.3 streaming replication bug ?
Date
Msg-id CAHGQGwH278NtJaN2w5bvahFZSA6obRsnRMk9K7Jb1wj=hyvL-Q@mail.gmail.com
Whole thread Raw
In response to [streaming replication] 9.1.3 streaming replication bug ?  (乔志强 <qiaozhiqiang@leadcoretech.com>)
Responses Re: [streaming replication] 9.1.3 streaming replication bug ?
List pgsql-general
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

pgsql-general by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: Is this doable using Postgresql crosstab or some other function?
Next
From: hamann.w@t-online.de
Date:
Subject: Re: question about alternate ordering of results