> > > Hence, I have created a script to perform RESUBSCRIBE NODE: > > Resub.sh script: > > cluster name = rep220; > node 1 admin conninfo='host=localhost dbname=postgres user=postgres > port=5555'; > node 2 admin conninfo='host=localhost dbname=postgres user=postgres > port=5556'; > node 3 admin conninfo='host=localhost dbname=postgres user=postgres > port=5557'; > resubscribe node ( origin = 1, provider = 2 , receiver = 3); > > While executing it gives me error as: > > -bash-4.1$ slonik resub_set.sh > resub_set.sh:8: PGRES_FATAL_ERROR lock table "_rep220".sl_event_lock, > "_rep220".sl_config_lock;select "_rep220".resubscribeNode(1, 2, 2); - >
> ERROR: insert or update on table "sl_subscribe" violates foreign key > constraint "sl_subscribe-sl_path-ref" > DETAIL: Key (sub_provider, sub_receiver)=(2, 2) is not present in table > "sl_path". > Merely a blind guess, any step ( between 5556 to 5557) I missed before executing RESUBSCRIBE NODE. --Raghav
_______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
