Antonio Escudero wrote: >The subscriber has caught up with the provider, >meaning the provider's DB has been copied to the >subscriber's DB and it is currently started processing >those queued SYNC. > >Can i add table x_tbl to one of the schema in the >provider's database without restarting again slony? > >Does slony add that table x_tbl to the subscriber's >database? if not, what do i need to do to update the >subscriber's db? > >If i delete a procedure in the provider's db, what do >i need to do to delete that procedure in the >subscriber's db? > > > I think we have a procedure described for this... Yup, we do...
http://slony-wiki.dbitech.ca/index.php/Howto/addtoreplication None of these steps require restarting Slony-I. Slony-I doesn't try to do anything directly about replicating things that aren't table tuples or sequence values. If you want to delete a stored function on all the nodes, you generally have two choices: 1. Send the request to all the nodes... for host in h1 h2 h3 h4; do psql -h $host -p 5434 -d my_replicated_database -c "drop function foo(integer);" done 2. Submit the request via the slonik "EXECUTE SCRIPT" command The amount of locking impact that EXECUTE SCRIPT has would cause me to prefer #1... _______________________________________________ Slony1-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/slony1-general
