check_slony_cluster.sh reports: OK - 0 nodes in sync
test_slony_state-db.pl reports:
Tests for node 1 - DSN = dbi:Pg:dbname=ddcKeyGen host=MASTERIP user=postgres
========================================
pg_listener info:
Pages: 0
Tuples: 0
Size Tests
================================================
sl_log_1 8 212.000000
sl_log_2 117 3133.000000
sl_seqlog 0 0.000000
Listen Path Analysis
===================================================
No problems found with sl_listen
--------------------------------------------------------------------------------
Summary of event info
Origin Min SYNC Max SYNC Min SYNC Age Max SYNC Age
================================================================================
1 96 1987 00:00:00 03:47:00 0
2 3 3 03:47:00 03:47:00 1
---------------------------------------------------------------------------------
Summary of sl_confirm aging
Origin Receiver Min SYNC Max SYNC Age of latest SYNC Age of
eldest SYNC
=================================================================================
1 2 97 97 03:46:00 03:46:00 1
2 1 3 3 03:47:00 03:47:00 1
------------------------------------------------------------------------------
Listing of old open connections on node 1
Database PID User Query Age
Query
================================================================================
Tests for node 2 - DSN = dbi:Pg:dbname=ddcKeyGen_slave host=SLAVEIP
user=postgres
========================================
pg_listener info:
Pages: 0
Tuples: 0
Size Tests
================================================
sl_log_1 0 0.000000
sl_log_2 0 0.000000
sl_seqlog 0 0.000000
Listen Path Analysis
===================================================
No problems found with sl_listen
--------------------------------------------------------------------------------
Summary of event info
Origin Min SYNC Max SYNC Min SYNC Age Max SYNC Age
================================================================================
1 96 97 03:47:00 03:47:00 1
2 3 3 03:48:00 03:48:00 1
---------------------------------------------------------------------------------
Summary of sl_confirm aging
Origin Receiver Min SYNC Max SYNC Age of latest SYNC Age of
eldest SYNC
=================================================================================
1 2 97 97 03:47:00 03:47:00 1
2 1 3 3 03:48:00 03:48:00 1
------------------------------------------------------------------------------
Listing of old open connections on node 2
Database PID User Query Age
Query
================================================================================
What do I do to get the initial copy working?
Thanks,
-at
_______________________________________________
Slony1-general mailing list
[email protected]
http://lists.slony.info/mailman/listinfo/slony1-general
