On Fri, Jul 1, 2011 at 2:42 PM, Erik Rijkers <er@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 synchronous_standby_names to be set?
Yes
Unset => "synchronise with zero servers" => asynchronous
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services