Hi, I need some help on slony.

1.  How will you know if slony replication is working correctly?

2.  How  will you know if data are being copied to the slave database?

3.  I tailed my slony log file and I got this:

 09:40:25 up 197 days,  4:03,  1 user,  load average: 0.00, 0.00, 0.00
[root at db2 postgres]# tail -f hba_db-slon.log
DEBUG2 cleanupThread:    0.053 seconds for vacuuming
DEBUG2 syncThread: new sl_action_seq 1 - SYNC 1424
DEBUG2 localListenThread: Received event 2,1424 SYNC
Wed Feb  8 09:43:01 PST 2006
DEBUG2 syncThread: new sl_action_seq 1 - SYNC 1425
DEBUG2 localListenThread: Received event 2,1425 SYNC
Wed Feb  8 09:44:01 PST 2006
DEBUG2 syncThread: new sl_action_seq 1 - SYNC 1426
DEBUG2 localListenThread: Received event 2,1426 SYNC
Wed Feb  8 09:45:01 PST 2006

------  I know that slony is running. but i tried to search one of the table built and it doesn't have any data...

hba_db=# select count(*) from lookup.state_tbl;
 count 
-------
     0
(1 row)

Am I doing it try?


			
---------------------------------
 Yahoo! Mail - Helps protect you from nasty viruses.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://gborg.postgresql.org/pipermail/slony1-general/attachments/20060208/452abf72/attachment.html