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 - [EMAIL PROTECTED]'); # STORE NODE store node (id = 2, event node = 1, comment = 'Node 2 - [EMAIL PROTECTED]'); 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 _______________________________________________ Slony1-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/slony1-general
