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: [email protected] [[email protected]]
on behalf of Andreas Kretschmer [[email protected]]
Sent: Thursday, December 03, 2015 10:49 PM
To: [email protected]
Subject: Re: [GENERAL] BDR: ALTER statement hanging
Selim Tuvi <[email protected]> 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 ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
