Geoffrey lists at serioustechnology.com
Wed Feb 20 12:37:53 PST 2008
I want to make sure that I'm not missing something in my configuration. 
A quick summary of my config and my startup procedures.

My nodes are defined as follows:

$CLUSTER_NAME = 'mwr_cluster';
$MASTERNODE = 1;
add_node(node     => 1,
          host     => 'mwr',
          dbname   => 'mwr',
          port     => 5436,
          user     => 'postgres',
              password => '');

add_node(node     => 2,
          host     => 'earth',
          dbname   => 'mwr',
          port     => 5436,
          user     => 'postgres',
              password => '');

My two sets are defined as follows:

$SLONY_SETS = {
     "avldsSet" => {
         "set_id" => 1,
         "table_id"    => 1,
         "sequence_id" => 1,
         "pkeyedtables" => [
		.
		.
	]
         "keyedtables" => {},
         "serialtables" => [],
         "sequences" => [
         	.
		.
         ],
     },
     "nonavldsSet" => {
         "set_id"       => 2,
         "table_id"     => 100,
         "sequence_id"  => 100,
         "pkeyedtables" => [
		.
		.
	]
         "keyedtables" => {},
         "serialtables" => [],
         "sequences" => [
		.
		.
	],
     },
}

I have no keyedtables, serialtables defined.  Note, the second set has:

"table_id"     => 100,
  "sequence_id"  => 100,

to insure they don't collide with the previous set.  The previous set 
has less the 100 tables and sequences, so this should not be an issue.

Does this look okay from a configuration perspective?

When I first start slony, I do the following:

slonik_init_cluster --config $CONFIG | slonik

slon_start --config $CONFIG 1
slon_start --config $CONFIG 2

slonik_create_set --config $CONFIG 1 | slonik
slonik_create_set --config $CONFIG 2 | slonik

slonik_subscribe_set --config $CONFIG 1 2 | slonik
slonik_subscribe_set --config $CONFIG 2 2 | slonik

-- 
Until later, Geoffrey

Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
  - Benjamin Franklin


More information about the Slony1-general mailing list