> Selim Tuvi <stuvi@xxxxxxx> hat am 4. Dezember 2015 um 18:46 geschrieben: > > > 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 > I think, the state 'i' is the main reason for your problem, because of: "i- Joining: The node is doing initial slot creation or an initial dump and load". But i can't tell you why this nodes are in this state. Regards, Andreas -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
