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
[EMAIL PROTECTED] 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 o f 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.
_______________________________________________ Slony1-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/slony1-general
