Fellugh fellugh at gmail.com
Thu Jan 29 00:58:08 PST 2009
Morning List,

I have successfully installed Slony1-2.0.0 against postgreSQL8.3.3.
Slony is running on one server, and master and slave DB are on 2 two 
servers.
The replication is working fine but I having troubles to run 
slonik_move_set script.

$ ./slonik_move_set 1 1 2
cluster name = my_cluster;
 node 1 admin conninfo='host=MasterSrv dbname=MasterDB user=postgres 
port=5432';
 node 2 admin conninfo='host=SlaveSrv dbname=SlaveDB user=postgres 
port=5432';
  echo 'Locking down set 1 on node 1';
  lock set (id = 1, origin = 1);
  wait for event (origin = 1, confirmed = 2);
  echo 'Locked down - moving it';
  move set (id = 1, old origin = 1, new origin = 2);
  echo 'Replication set 1 moved from node 1 to 2.  Remember to';
  echo 'update your configuration file, if necessary, to note the new 
location';
  echo 'for the set.';

$ ./slonik_move_set 1 1 2 | slonik
<stdin>:7: Error: No admin conninfo provided for node -1

If someone could point me to a direction to slove my problem...

Thanks in advance

Fel




More information about the Slony1-general mailing list