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