From: | Martin Gudmundsson <martingudmundsson(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: BDR: Strange values in pg_stat_replication |
Date: | 2014-07-14 20:29:03 |
Message-ID: | 7CD80751-D8A0-434C-BB90-0A74A8B06997@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 <martingudmundsson(at)gmail(dot)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
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Néstor Boscán | 2014-07-14 22:33:00 | Quering complete PLPGSQL code |
Previous Message | Jeff Janes | 2014-07-14 20:20:06 | Re: Why corruption memory in one database affects all the cluster? |