I'm testing synchronous replication on 9.2devel - both instances are on a
single machine.
The primary shows synchronous_commit = on
and synchronous_standby_names = ''.
The standby receives updates fine.
Now, does the 'synchronous_commit = on' absolutely mean that the session is
On Fri, Jul 1, 2011 at 2:42 PM, Erik Rijkers e...@xs4all.nl wrote:
Two questions:
1. How to query a session to make absolutely sure that replication is
actually synchronous?
Check synchronous_standby_names and synchronous commit for appropriate values.
2. Does sync-repl really need
Simon Riggs si...@2ndquadrant.com writes:
On Fri, Jul 1, 2011 at 2:42 PM, Erik Rijkers e...@xs4all.nl wrote:
Two questions:
1. How to query a session to make absolutely sure that replication is
actually synchronous?
Check synchronous_standby_names and synchronous commit for appropriate