-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Le 13/04/2011 15:08, [email protected] 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 [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
