Tue Jan 30 13:47:10 PST 2007
- Previous message: [Slony1-general] REPLICATIONUSER really needs to be super-user?
- Next message: [Slony1-general] REPLICATIONUSER really needs to be super-user?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
* Mark Stosberg <mark at summersault.com> [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
- Previous message: [Slony1-general] REPLICATIONUSER really needs to be super-user?
- Next message: [Slony1-general] REPLICATIONUSER really needs to be super-user?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list