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
_______________________________________________
Slony1-general mailing list
[email protected]
http://lists.slony.info/mailman/listinfo/slony1-general
