1. I know now that slony is working, but i still want to know on how long will it take to finish replicating a large database?
2. I used ps -aux to look at processing on my system.
then i got this

USER       PID %CPU %MEM   VSZ  RSS TTY      STAT START   TIME COMMAND
postgres 24723  0.0  0.9 899824 59564 ?      S    Feb14   0:12 postgres: postgres database_name 66.94.234.13(47439) idle      
postgres 24728  5.7 13.6 903412 837340 ?     D    Feb14 169:39 postgres: postgres database_name 66.94.234.13(47440) COPY      
postgres 24729  0.0  0.9 899016 55732 ?      S    Feb14   0:25 postgres: postgres database_name 66.94.234.13(47441) idle      
postgres 24730  0.0  4.5 900136 277144 ?     S    Feb14   0:36 postgres: postgres database_name 66.94.234.13(47442) idle      

does this means that it is still replicating the database? 
what does  Feb14 169:39 postgres: postgres database_name 66.94.234.13(47440) COPY  means? 

3.  I tried to query some tables in the slave database.  Unfortunately, the tables are locked.  How will i know that the data are being copied or appended to the slave database?

4.  Does this query tell that slony is appending the slave db (db_name)?
 postgres=# select * from pg_stat_database;
   datid   |  datname  | numbackends | xact_commit | xact_rollback | blks_read | blks_hit 
-----------+-----------+-------------+-------------+---------------+-----------+----------
         1 | template1 |           0 |         100 |            12 |         0 |        0
     17229 | template0 |           0 |           0 |             0 |         0 |        0
 675239438 | db_name    |         300 |       40965 |         14011 |         0 |        0
(3 rows)

5  In my slony log file, i got the following now:

DEBUG2 remoteListenThread_1: queue event 1,1471 SYNC
DEBUG2 remoteListenThread_1: queue event 1,1472 SYNC
DEBUG2 syncThread: new sl_action_seq 1 - SYNC 222
DEBUG2 remoteListenThread_1: queue event 1,1473 SYNC
DEBUG2 localListenThread: Received event 2,222 SYNC
DEBUG2 remoteListenThread_1: queue event 1,1474 SYNC
DEBUG2 remoteListenThread_1: queue event 1,1475 SYNC
DEBUG2 remoteListenThread_1: queue event 1,1476 SYNC
Tue Feb 14 14:11:01 PST 2006
DEBUG2 remoteListenThread_1: queue event 1,1477 SYNC
 
 Thanks for the help


		
---------------------------------
 Yahoo! Autos. Looking for a sweet ride? Get pricing, reviews, & more on new and used cars.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://gborg.postgresql.org/pipermail/slony1-general/attachments/20060216/7db68f47/attachment.html