hi,
the master is grade1 database. The others database must be only slaves because 
they have other tables with different data.
Grade1 must be a master.I run subscribe script in putty and now i see these 
messages:

NOTICE:  truncate of "public"."friends" succeeded
NOTICE:  truncate of "public"."user_tokens" succeeded
NOTICE:  truncate of "public"."client_applications" failed - doing delete
NOTICE:  truncate of "public"."gps_points" succeeded
NOTICE:  truncate of "public"."countries" succeeded
NOTICE:  truncate of "public"."gpx_file_tags" succeeded
NOTICE:  truncate of "public"."gpx_files" failed - doing delete
NOTICE:  truncate of "public"."diary_comments" succeeded
NOTICE:  truncate of "public"."languages" failed - doing delete
NOTICE:  truncate of "public"."diary_entries" failed - doing delete
NOTICE:  truncate of "public"."messages" succeeded
NOTICE:  truncate of "public"."friends" succeeded
NOTICE:  truncate of "public"."oauth_nonces" succeeded
NOTICE:  truncate of "public"."gps_points" succeeded
NOTICE:  truncate of "public"."oauth_tokens" succeeded
NOTICE:  truncate of "public"."gpx_file_tags" succeeded
NOTICE:  truncate of "public"."user_blocks" succeeded
NOTICE:  truncate of "public"."gpx_files" failed - doing delete
NOTICE:  truncate of "public"."languages" failed - doing delete
NOTICE:  truncate of "public"."user_preferences" succeeded
NOTICE:  truncate of "public"."user_roles" succeeded
NOTICE:  truncate of "public"."messages" succeeded
NOTICE:  truncate of "public"."user_tokens" succeeded
NOTICE:  truncate of "public"."oauth_nonces" succeeded
NOTICE:  truncate of "public"."oauth_tokens" succeeded
NOTICE:  truncate of "public"."user_blocks" succeeded
NOTICE:  truncate of "public"."user_preferences" succeeded
NOTICE:  truncate of "public"."user_roles" succeeded
NOTICE:  truncate of "public"."user_tokens" succeeded


It is all ok?. I check in the databases and for now only grade1 database have 
just tables "in replication".
I need to wait?

Thanks

Francesco



>----Messaggio originale----
>Da: stephane.schildknecht at postgresql.fr
>Data: 13/04/2011 15.49
>A: <slony1-general at lists.slony.info>
>Ogg: Re: [Slony1-general] R: Re:  Slony Problems
>
>-----BEGIN PGP SIGNED MESSAGE-----
>Hash: SHA1
>
>Le 13/04/2011 15:08, francescoboccacci at libero.it a écrit :
>> 
>> Hi, and thanks.
>> in The attach are two file: creation of cluster and subscribe.
>> These are my steps:
>> 
>> 1-run cluster_setup_grade_allgrades.sh
>
>You should store path in two ways.
>(i.e 1-2 and 2-1).
>Especially if you ever wants to switch between nodes (otherwise, you can 
easily
>set forward=no when subscribing).
>
>Are all your databases local and in the same PG instance ?
>
>> 2:
>> 
>> Master grade 1 --Slave grade2
>> /usr/lib/postgresql/8.4/bin/slon sql_cluster_allgrades "dbname=grade1 
>> user=navmap" > slon1_2.log &
>> /usr/lib/postgresql/8.4/bin/slon sql_cluster_allgrades "dbname=grade2 
>> user=navmap" > slon2_1.log &
>> 
>> Master grade 1 --Slave grade3
>> /usr/lib/postgresql/8.4/bin/slon sql_cluster_allgrades "dbname=grade1 
>> user=navmap" > slon1_3.log &
>> /usr/lib/postgresql/8.4/bin/slon sql_cluster_allgrades "dbname=grade3 
>> user=navmap" > slon3_1.log &
>> 
>> Master grade 1 --Slave grade4
>> /usr/lib/postgresql/8.4/bin/slon sql_cluster_allgrades "dbname=grade1 
>> user=navmap" > slon1_4.log &
>> /usr/lib/postgresql/8.4/bin/slon sql_cluster_allgrades "dbname=grade4 
>> user=navmap" > slon4_1.log &
>> 
>> Master grade 1 --Slave grade9
>> /usr/lib/postgresql/8.4/bin/slon sql_cluster_allgrades "dbname=grade1 
>> user=navmap" > slon1_9.log &
>> /usr/lib/postgresql/8.4/bin/slon sql_cluster_allgrades "dbname=grade9 
>> user=navmap" > slon9_1.log &
>> 
>> I need to run slon twice time for master and 1 slave..am i right?
>
>No you're not. You just have to start ONE daemon for each node.
>
>> 
>> 3-subscribe_allgrades.sh
>> 
>> What it si wrong or all is correct?
>
>How does it work?
>
>- -- 
>Stéphane Schildknecht
>Loxodata
>Contact régional PostgreSQL
>
>-----BEGIN PGP SIGNATURE-----
>Version: GnuPG v1.4.10 (GNU/Linux)
>Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/
>
>iEYEARECAAYFAk2lqecACgkQA+REPKWGI0FPmACgnpHnkKinAp1YEXAKg4BqUi7I
>+jIAninuRWhvD+AaT5ImvqZMi2cVPT8u
>=v/mF
>-----END PGP SIGNATURE-----
>_______________________________________________
>Slony1-general mailing list
>Slony1-general at lists.slony.info
>http://lists.slony.info/mailman/listinfo/slony1-general
>