BUG #6018: ctrl +C cause data inconsistent for sync standby

From: "lxzou" <zoulx1982(at)163(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #6018: ctrl +C cause data inconsistent for sync standby
Date: 2011-05-10 02:38:42
Message-ID: 201105100238.p4A2cgx4000328@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 6018
Logged by: lxzou
Email address: zoulx1982(at)163(dot)com
PostgreSQL version: 9.1beta1
Operating system: Linux
Description: ctrl +C cause data inconsistent for sync standby
Details:

Dear Sir:
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.
Thank you for your time.
Look forward to your reply.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Robert Haas 2011-05-10 02:38:52 Re: Upgrading from 1.10 to 1.12 - cannot set up server
Previous Message Robert Haas 2011-05-10 02:38:03 Re: BUG #5992: The database cluster initialisation failed