Hi,

I set up what would appear to be a fairly simple replication between 
(large - multi GB) data bases. Replication appears to start fine.

However I experienced problems inserting data into the master database 
during the initial copy process.  The error was:

        'permission denied for sequence sl_action_seq'

The process doing the insert was using a different user (with less 
permissions) than the replication (which is using the postgres user).

I did not see anything about this in the documentation, but presumably I 
also need to grant permissions to the inserting user on the Slony 
tables/sequences.  Is there a list of what permissions need to be changed?

Thanks,

David.
-- 
David Brain - bandwidth.com
[EMAIL PROTECTED]
919.297.1078
_______________________________________________
Slony1-general mailing list
[email protected]
http://gborg.postgresql.org/mailman/listinfo/slony1-general

Reply via email to