Search Postgresql Archives

Re: [streaming replication] 9.1.3 streaming replication bug ?

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

 



On Mon, Apr 9, 2012 at 7:33 PM, 乔志强 <qiaozhiqiang@xxxxxxxxxxxxxxxx> 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

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[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