Hi! Never mind this one. Wrong config of synchronous replication by me. It looks good once I got the replication setup correctly.
Kind regards, Martin 13 jul 2014 kl. 23:10 skrev Martin Gudmundsson <martingudmunds...@gmail.com>: > Hi! > I wanted to test synchronous bi-dircetional replication using > synchronous_standby_names with bdr. > > So I set this up as follows: > Node alpha has the following settings in postgresql.conf > > port=5432 > wal_level = 'logical' > max_replication_slots = 3 > max_wal_senders = 4 > synchronous_standby_names=’beta' > shared_preload_libraries = 'bdr' > bdr.connections='beta' > bdr.beta_dsn = ’dbname=bdrdemo username=postgres port=5433' > track_commit_timestamp = on > > > Node beta has the following settings in postgresql.conf > > port=5433 > wal_level = 'logical' > max_replication_slots = 3 > max_wal_senders = 4 > synchronous_standby_names=’alpha' > shared_preload_libraries = 'bdr' > bdr.connections=’alpha' > bdr.alpha_dsn = ’dbname=bdrdemo username=postgres port=5432' > track_commit_timestamp = on§ 1 > bdr.alpha_init_replica = on > bdr.alpha_replica_local_dsn = 'dbname=bdrdemo user=postgres port=5432’ > > It seems to work fine. Bringing down one node stalls the other one, just like > synch rep should. > > But the view pg_stat_replication view shows async in sync_state column. > Shouldn’t this really be sync? > > > Kind regards, Martin > > -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
