[HACKERS] must synchronous_standby_names be set?

2011-07-01 Thread Erik Rijkers
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

Re: [HACKERS] must synchronous_standby_names be set?

2011-07-01 Thread Simon Riggs
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

Re: [HACKERS] must synchronous_standby_names be set?

2011-07-01 Thread Jaime Casanova
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