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