Mon Mar 29 15:41:56 PDT 2010
- Previous message: [Slony1-general] Slony 2.0.2 and PostgreSQL 8.4: initial copy fails (Could not lock table on subscriber)
- Next message: [Slony1-general] Slony 2.0.2 and PostgreSQL 8.4: initial copy fails (Could not lock table on subscriber)
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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
- Previous message: [Slony1-general] Slony 2.0.2 and PostgreSQL 8.4: initial copy fails (Could not lock table on subscriber)
- Next message: [Slony1-general] Slony 2.0.2 and PostgreSQL 8.4: initial copy fails (Could not lock table on subscriber)
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list