On 7/11/2006 1:36 PM, Richard Yen wrote: > Hi, > > I recently did a MOVE SET switchover from node 1 to node 3 on a 3- > node system. So, all that remains are nodes 2 and 3, while we run > hardware tests on node 1. > > What I'm trying to do now is to add a node 4 to serve as a relay to > an offsite node. > > However, when I try to run a slonik script, I get the following error > message: > Error: No admin conninfo provided for node 1 > > Since node 1 is inactive (and no longer in the sl_nodes, sl_path, > etc. tables), how can I run a slonik script?
Add "event node = 3" to the commands that fail. The default event node is 1. Also, are you going to have node 1 offline for so long that it warrants a complete rebuild as opposed to a catch up? If the DB isn't heavily updated, it might have been possible to just take it offline, let it later catch up and switch back. Jan -- #======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #================================================== [EMAIL PROTECTED] # _______________________________________________ Slony1-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/slony1-general
