> Slon needs superuser access including catalog update permission on the 
> local database. Otherwise it can neither perform the commands required 
> to subscribe to a set, nor could it ever do anything like failover or 
> switchover.

With PostgreSQL 8.1 it appears you can shove Slony into a ROLE with
ownership of tables and schemas it replicates instead of a superuser
account.

The exception to this seems to be the various system catalogue updates
like the index detachment during COPY.
--