Tue Jan 20 07:50:17 PST 2009
- Previous message: [Slony1-general] Timing in Slony1 2.0
- Next message: [Slony1-general] Switchover Error
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
My configuration is as follows :
psql db1 -c 'select * from "_CLUSTER1".sl_subscribe'
sub_set | sub_provider | sub_receiver | sub_forward | sub_active
---------+--------------+--------------+-------------+------------
1 | 3 (M2)| 1 (M1)| t | t
1 | 1 (M1)| 2 (S1) | t | t
1 | 3 (M2)| 4 (S2) | t | t
When I check sl_confirm using the script provided I get :
con_origin | con_received | minseq | maxseq | age1 | age2 |
tooold
------------+--------------+----------+----------+----------+----------+--------
1 | 2 | 29365860 | 29365951 | 00:00:00 | 00:15:00 | f
1 | 3 | 29365860 | 29365952 | 00:00:00 | 00:15:00 | f
1 | 4 | 29365860 | 29365952 | 00:00:00 | 00:15:00 | f
2 | 4 | 337242 | 337333 | 00:00:00 | 00:15:00 | f
3 | 1 | 19073648 | 19074557 | 00:00:00 | 00:15:00 | f
3 | 2 | 19073648 | 19074551 | 00:00:00 | 00:15:00 | f
3 | 4 | 19073650 | 19074558 | 00:00:00 | 00:15:00 | f
4 | 1 | 14353126 | 14353217 | 00:00:00 | 00:15:00 | f
4 | 2 | 14353126 | 14353217 | 00:00:00 | 00:15:00 | f
4 | 3 | 14353126 | 14353217 | 00:00:00 | 00:15:00 | f
psql db1 -c 'select pa_server,pa_client from "_CLUSTER1".sl_path'
pa_server | pa_client
-----------+-----------
1 | 4
3 | 4
1 | 3
4 | 3
3 | 1
4 | 1
2 | 4
2 | 3
2 | 1
1 | 2
3 | 2
4 | 2
Do I have to worry about the fact that no event are sent from node 2 to
nodes 1 and 3. I can see in sl_listen that all combinations of paths
have been created. But, Why node 1 send events to node 3 and node 4 and
node 2 does not send events to his provider ?
Regards
--
Cyril SCETBON
Happy New Year
- Previous message: [Slony1-general] Timing in Slony1 2.0
- Next message: [Slony1-general] Switchover Error
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list