On Thu, Nov 1, 2012 at 1:03 PM, David Fetter <da...@fetter.org> wrote:
> On Wed, Oct 31, 2012 at 06:39:20PM -0700, Peter van Hardenberg wrote:
> > This was rather surprising - my synchronous commit was... not
> > cancelled. Is this expected behaviour?
>
> I believe it is.
>
> Does the following do the right thing?
>
> SET synchronous_commit='on';
> BEGIN;
> INSERT INTO data VALUES ('baz');
> COMMIT;^c
>
> Oh, and how did you get that cancel in?
>
He enforced a manual cancel from client with something like Ctrl+C to
cancel query.
In this case you do not wait for the slave to confirm that the commit
information has been flushed on its disk.
--
Michael Paquier
http://michael.otacoo.com
