http://www.slony.info/bugzilla/show_bug.cgi?id=373

           Summary: Privileges for slon remote connections
           Product: Slony-I
           Version: devel
          Platform: All
        OS/Version: All
            Status: NEW
          Severity: enhancement
          Priority: low
         Component: docs
        AssignedTo: slony1-bugs at lists.slony.info
        ReportedBy: pv.slony at digitalfuture.it
                CC: slony1-bugs at lists.slony.info
   Estimated Hours: 0.0


Docs say [*]:
 The slon daemon needs to connect to remote databases with sufficient
permissions to:

    SELECT from sl_event

    SELECT the sl_log_1 and sl_log_2 tables

    SELECT any replicated tables that originate on the remote node. This is
done as part of the initial COPY during the subscription process

Note that this role does not have any need to modify data; it purely involves
SELECT access.


That advice appears to be incorrect in that slon calls registerNodeConnection()
which tries to insert a row to the sl_nodelock table and fails.


[*] http://www.slony.info/documentation/2.5/security.html

-- 
Configure bugmail: http://www.slony.info/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.
You are the assignee for the bug.