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