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
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?

3-subscribe_allgrades.sh

What it si wrong or all is correct?

Thanks


Francesco














>----Messaggio originale----
>Da: [email protected]
>Data: 13/04/2011 13.57
>A: <[email protected]>
>Ogg: Re: [Slony1-general] Slony Problems
>
>-----BEGIN PGP SIGNED MESSAGE-----
>Hash: SHA1
>
>Le 13/04/2011 12:45, [email protected] a écrit :
>> Hi to all,
>> i have a problem with slony -I. I try to create a replication cluster 
between 
>> 1 mastere and 4 slaves (check the attach if right).
>> I run attach script but after 5 minutes i check that i still running when 
>> arrive at user table. 
>> User table is a backup restor of the Matser user table.
>> Someone can help me?
>> 
>
>Hi,
>
>The subscribe part of the replication initialisation is missing.
>
>Regards,
>- -- 
>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/
>
>iEYEARECAAYFAk2lj54ACgkQA+REPKWGI0H6XgCgksUwz9CKZKEf2xg+voagLbGm
>NkcAoK7L5Gaxr/3KPcJ/TTv82N2HxyvE
>=QjeM
>-----END PGP SIGNATURE-----
>_______________________________________________
>Slony1-general mailing list
>[email protected]
>http://lists.slony.info/mailman/listinfo/slony1-general
>

Attachment: cluster_setup_grade_allgrades.sh
Description: Bourne shell script

Attachment: subscribe_allgrades.sh
Description: Bourne shell script

_______________________________________________
Slony1-general mailing list
[email protected]
http://lists.slony.info/mailman/listinfo/slony1-general

Reply via email to