On 10/31/12 9:39 PM, Peter van Hardenberg wrote:
> This was rather surprising - my synchronous commit was... not cancelled.
> Is this expected behaviour?
> d5r5fdj6u5ieml=> begin;
> d5r5fdj6u5ieml=> set synchronous_commit = 'on';
> d5r5fdj6u5ieml=> insert into data values ('baz');
> INSERT 0 1
> d5r5fdj6u5ieml=> commit;
> ^CCancel request sent
> WARNING: canceling wait for synchronous replication due to user request
> DETAIL: The transaction has already committed locally, but might not
> have been replicated to the standby.
> d5r5fdj6u5ieml=> select * from data;
> (2 rows)
Did the inserted row also arrive at the standby?
In response to
pgsql-hackers by date
|Next:||From: Matthew Gerber||Date: 2012-11-02 18:25:33|
|Subject: Unresolved error 0xC0000409 on Windows Server|
|Previous:||From: Shaun Thomas||Date: 2012-11-02 17:51:21|
|Subject: Re: Synchronous commit not... synchronous?|