cbbrowne at ca.afilias.info cbbrowne
Sun Feb 6 20:13:38 PST 2005
> I need to update two functions within our master database that is
> replicated to a slave using Slony. The updated functions are needed on
> both the master and slave. It's needed on the slave in case we have to
> failover to it...
>
> Can I safely apply the new functions scripts (pl/pgsql) to both the
> slave and master (ignoring the fact that slony is installed)? Or do I
> have to use the slony EXECUTE SCRIPT command for this? No table or data
> changes are required.
>
> I just wanted to check before I screw up the cluster!

No, that won't mess anything up.

Similarly, creating extra indices could be done (and probably should be)
without resorting to EXECUTE SCRIPT.

There points to some more docs that need to be...



More information about the Slony1-general mailing list