Sat Aug 2 16:33:18 PDT 2008
- Previous message: [Slony1-general] provider I/P address has been changed
- Next message: [Slony1-general] How to add more slaves to an existing replication set
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Hi All; I setup a single master & slave like this: - I did a pg_dump from the master to the slave - set the cluster name - init cluster ( id=1, comment = 'Master Node'); - create set ( id=1, origin=1, comment = 'PA REPLICATION SET' ); - ran all the 'set add table' commands - store node (id=2, comment = 'Slave Node 1'); - store path (server = 1, client = 2, conninfo='dbname=$MASTERDBNAME host=$MASTERHOST port=$MASTERPORT user=$REPUSER'); - store path (server = 2, client = 1, conninfo='dbname=$SLAVEDBNAME host=$SLAVEHOST port=$SLAVEPORT user=$REPUSER'); - store listen (origin=1, provider = 1, receiver =2); - store listen (origin=2, provider = 2, receiver =1); - started the slon daemon on the master: slon $CLUSTERNAME "dbname=$MASTERDBNAME port=$MASTERPORT host= $MASTERHOST user=$REPUSER" > ./slon.master.log 2>&1 & - started the slon daemon on the slave - subscribe set ( id = 1, provider = 1, receiver = 2, forward = no); Now I want to add 2 more slaves, I plan to run this: - do a pg_dump from the master to slaves 3 & 4 - store node (id=3, comment = 'Slave Node 2'); - store node (id=4, comment = 'Slave Node 3'); - store path (server = 1, client = 3, conninfo='dbname=$MASTERDBNAME host=$MASTERHOST port=$MASTERPORT user=$REPUSER'); - store path (server = 3, client = 1, conninfo='dbname=$SLAVEDBNAME host=$SLAVEHOST port=$SLAVEPORT user=$REPUSER'); - store path (server = 1, client = 4, conninfo='dbname=$MASTERDBNAME host=$MASTERHOST port=$MASTERPORT user=$REPUSER'); - store path (server = 4, client = 1, conninfo='dbname=$SLAVEDBNAME host=$SLAVEHOST port=$SLAVEPORT user=$REPUSER'); - store listen (origin=1, provider = 1, receiver =3); - store listen (origin=3, provider = 3, receiver =1); - store listen (origin=1, provider = 1, receiver =4); - store listen (origin=4, provider = 4, receiver =1); - Start the slon daemon on slaves 3 & 4 - subscribe set ( id = 1, provider = 1, receiver = 3, forward = no); - subscribe set ( id = 1, provider = 1, receiver = 4, forward = no); Is this correct, or am I missing something here? Thanks in advance /Kevin
- Previous message: [Slony1-general] provider I/P address has been changed
- Next message: [Slony1-general] How to add more slaves to an existing replication set
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list