Andreas Kostyrka andreas
Tue Jan 30 13:47:10 PST 2007
* 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



More information about the Slony1-general mailing list