On Tue, May 10, 2011 at 11:38 AM, lxzou <zoulx1...@163.com> wrote: > I am interested in standby function of PG, so i test the new feature about > sync standby in PG9.1. I have a question, i install only one primary > postgres and no standby server. When i execute an insert statement in > primary, this statement was blocked. But when I press Ctrl + C in psql, the > statement was commited. In my view, the walsender can't send the xlog to > standby server, the statement should be rollback, but not commit; because > this will cause the data between primary and standby inconsistent.
The transaction gets blocked by sync rep *after* it's committed on the master. So, we cannot rollback such a transaction because it's already been committed on the master (i.e., WAL has already been flushed to the disk). Regards, -- Fujii Masao NIPPON TELEGRAPH AND TELEPHONE CORPORATION NTT Open Source Software Center -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
