I suspect that it's because the tables are not in the "public" schema. I've run into problems similar to this in the past, and the cause of it was that my tables were not in the public schema, but in a different one. The quick-fix is to edit create_slon.sh and replace "public" with whatever schema name (or just change the query to encompass a larger set of schema names). I haven't had a chance to go in and create a patch, but I'm wondering if this is what the problem is.
--Richard On Mar 25, 2010, at 3:07 AM, Stéphane A. Schildknecht wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > Le 23/03/2010 15:38, Hari Kiran a écrit : >> Hello Team, >> >> Request your help in finding the issue with Slony replication. This is a >> new Slony setup of 381 Tables & 282 Sequences (the DB size of master is >> 160GB) >> >> Steps I followed are: >> >> Initialize the slony setup: >> ./slonik_init_cluster -c slon_tools.conf| ./slonik >> ================================= >> Creating SETS: >> ./slonik_create_set -c slon_tools.conf 1|./slonik >> Starting Slon Deamons and Watchdog process >> ./slon_start -c slon_tools.conf 1 >> ./slon_start -c slon_tools.conf 2 >> ================================= >> Subscribing sets: >> Usage: subscribe_set [--config file] set# node# >> ./slonik_subscribe_set -c slon_tools.conf 1 2|slonik >> >> After subscribing the set, I am seeing the below logging in the logs >> directory of Slony. I never saw the statements "Truncating table"... >> Is the Slony performing the replication or not? When I am seeing the >> logs of node1, I see the following... >> > (...) > >> Appreciate your time and help. >> >> Thanks & Regards >> Hari Kiran >> >> > > Hi, > > Did you define tables and sequences to add to set 1, and how ? > > Regards, > - -- > Stéphane Schildknecht > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.4.9 (GNU/Linux) > Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org > > iEYEARECAAYFAkurNeEACgkQA+REPKWGI0GyWQCZATnWvlJFh85H19Vl/xHQXVbX > HFAAoKn6USzClCbR5AEyr24lfvkupdiE > =0K0I > -----END PGP SIGNATURE----- > _______________________________________________ > Slony1-general mailing list > [email protected] > http://lists.slony.info/mailman/listinfo/slony1-general _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
