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 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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers