> 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. -- _______________________________________________ Slony1-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/slony1-general
