We have recently installed slony and tsrted replication on one of our test machines. When we start inserting data in to the replicated database, the replication is taking properly. Over a period of time the lag increases between the two database.
Looking further we found that, sl_log_1 and sl_log2 are not getting truncated. Following are the versions which we are using. Slony has been installed for the first time
Postgres version: 8.3.5 slony version: 2.0.0
Can someone let me know what we should be looking at?
Following is the error which we get:
NOTICE: Slony-I: cleanup stale sl_nodelock entry for pid=17961 CONTEXT: SQL statement "SELECT "_inventorycluster".cleanupNodelock()" PL/pgSQL function "cleanupevent" line 83 at PERFORM NOTICE: Slony-I: Logswitch to sl_log_1 initiated CONTEXT: SQL statement "SELECT "_inventorycluster".logswitch_start()" PL/pgSQL function "cleanupevent" line 101 at PERFORM 2009-01-06 22:10:43 PST INFO cleanupThread: 0.149 seconds for cleanupEvent() 2009-01-06 22:10:43 PST ERROR cleanupThread: "vacuum analyze "_inventorycluster".sl_event;" - 2009-01-06 22:10:43 PST ERROR cleanupThread: "vacuum analyze "_inventorycluster".sl_confirm;" - 2009-01-06 22:10:43 PST ERROR cleanupThread: "vacuum analyze "_inventorycluster".sl_setsync;" - 2009-01-06 22:10:43 PST ERROR cleanupThread: "vacuum analyze "_inventorycluster".sl_log_1;" - 2009-01-06 22:10:43 PST ERROR cleanupThread: "vacuum analyze "_inventorycluster".sl_log_2;" - 2009-01-06 22:10:43 PST ERROR cleanupThread: "vacuum analyze "_inventorycluster".sl_seqlog;" - 2009-01-06 22:10:43 PST ERROR cleanupThread: "vacuum analyze "_inventorycluster".sl_archive_counter;" - 2009-01-06 22:10:43 PST ERROR cleanupThread: "vacuum analyze "pg_catalog".pg_listener;" - 2009-01-06 22:10:43 PST ERROR cleanupThread: "vacuum analyze "pg_catalog".pg_statistic;" - 2009-01-06 22:10:43 PST INFO cleanupThread: 0.280 seconds for vacuuming NOTICE: Slony-I: log switch to sl_log_1 still in progress - sl_log_2 not truncated CONTEXT: PL/pgSQL function "cleanupevent" line 99 at assignment 2009-01-06 22:21:31 PST INFO cleanupThread: 0.127 seconds for cleanupEvent()
