Yes they seem to be active:
deliver=# select * from pg_replication_slots;
slot_name | plugin | slot_type | datoid | database | active | xmin | catalog_xmin | restart_lsn
------------------------------------------+--------+-----------+--------+----------+--------+------+--------------+-------------
bdr_533136_6223770712502831127_1_16389__ | bdr | logical | 533136 | deliver | t | | 182302 | 0/9C8A5598
bdr_533136_6223800735012265413_1_16389__ | bdr | logical | 533136 | deliver | t | | 182302 | 0/9C8A5598
(2 rows)
Although when I look at bdr.bdr_nodes I see the status as still initializing for the other two nodes, I don't know if that could cause this problem:
deliver=# select * from bdr.bdr_nodes;
node_sysid | node_timeline | node_dboid | node_status | node_name | node_local_dsn
| node_init_from_dsn
---------------------+---------------+------------+-------------+-------------------------------------+---------------------------------------------------------------
-----------------------------------------+------------------------------------------------------------------------------------------------------
6212648563684174798 | 1 | 533136 | r | pe-deliverdb-sf-01v | host=pe-deliverdb-sf-01v port=5432 dbname=deliver user=deliver_admin password=xxxxx |
6223770712502831127 | 1 | 16389 | i | pe-deliverdb-sing-01v | host=pe-deliverdb-sing-01v port=5432 dbname=deliver user=deliver_admin password=xxxxx | host=pe-deliverdb-sf-01v port=5432 dbname=deliver user=deliver_admin password=xxxxx
6223800735012265413 | 1 | 16389 | i | pe-deliverdb-lon-01v | host=pe-deliverdb-lon-01v port=5432 dbname=deliver user=deliver_admin password=xxxxx | host=pe-deliverdb-sf-01v port=5432 dbname=deliver user=deliver_admin password=xxxxx
-Selim
________________________________________
From: pgsql-general-owner@xxxxxxxxxxxxxx [pgsql-general-owner@xxxxxxxxxxxxxx] on behalf of Andreas Kretschmer [akretschmer@xxxxxxxxxxxxx]
Sent: Thursday, December 03, 2015 10:49 PM
To: pgsql-general@xxxxxxxxxxxxxx
Subject: Re: BDR: ALTER statement hanging
Selim Tuvi <stuvi@xxxxxxx> wrote:
> Hi, I am running a three node BDR cluster. BDR version is 0.9.3. Postgres
> version is 9.4.5.
>
> With 0.9.2, I used to be able to issue ALTER statements using psql and it would
> go through. This time it is just hanging. The statement is this:
for ddl-commands all nodes MUST be active in replication, so have you
checked that in pg_replication_slots?
Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknown)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
