* Mark Stosberg <[EMAIL PROTECTED]> [070130 22:40]: > > Hello, > > The docs in firstdb.sgml say > > "The <envar>REPLICATIONUSER</envar> needs to be a &postgres; superuser." > > >From my own testing, that doesn't seem to be true. I connect as a user > that owns the database it's connecting to (and all objects in it), and > that seems to be sufficient. > > I did use the PostgreSQL super-user for the dump/schema restore and > adding in the PL/pgSQL language, but it doesn't seem to be necessary > for the ongoing replication process. > > (Or have I just not run into a hidden danger of not being a super-user?)
Well, sarcastically speaking, yes. slony does catalog manipulations on the slaves (to disable triggers), and I'm not sure if you can do that without being a superuser. Andreas _______________________________________________ Slony1-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/slony1-general
