Mark Stosberg mark
Tue Jan 30 13:31:19 PST 2007
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?)

   Mark




More information about the Slony1-general mailing list