Dave Cramer davec
Tue May 30 04:21:07 PDT 2006
I have two nodes, a master and a slave

If I run the slon's on the master it all works fine.

If I run one slon on the master, and one slon on the slave I get an  
error saying that the slony schema doesn't exist.

The master is 7.4.x, the slave is 8.1.x slony 1.1.5

the error occurs at

2006-05-29 16:48:35 PDT DEBUG2 remoteListenThread_1: start listening  
for event origin 1
2006-05-29 16:48:35 PDT ERROR  remoteListenThread_1: "listen  
"_cedarlane_repl_Event"; listen "_cedarlane_repl_Confirm"; select  
"_cedarlane_repl".registerNodeConnection(2); " - ERROR:  schema  
"_cedarlane_repl" does not exist


So for setting it up I run

cluster name = cedarlane_repl;
node 1 admin conninfo='host=localhost dbname=cedarlane user=postgres  
port=5432';
node 2 admin conninfo='host=10.1.0.93 dbname=cedarrep user=postgres  
port=5432';
   init cluster (id = 1, comment = 'Node 1 - cedarlane at localhost');

# STORE NODE
   store node (id = 2, event node = 1, comment = 'Node 2 -  
cedarrep at 10.1.0.93');
   echo 'Set up replication nodes';

# STORE PATH
   echo 'Next: configure paths for each node/origin';
   store path (server = 2, client = 1, conninfo = 'host=10.1.0.93  
dbname=cedarrep user=postgres port=5432');
   store path (server = 1, client = 2, conninfo = 'host=localhost  
dbname=cedarlane user=postgres port=5432');

# STORE LISTEN
   store listen (origin = 1, receiver = 2, provider = 1);
   store listen (origin = 2, receiver = 1, provider = 2);


and create set

on the master

then start the slon's on each node

As long as they run on the same machine everything is good.

Dave




More information about the Slony1-general mailing list