On Fri, 2007-02-09 at 09:14 -0500, David Brain wrote:
> '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 recommend not using the "postgres" user but instead creating a new
user called "slony" and setting it to be a superuser.
> 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?
>
You don't need to do that. I think something is broken with your
configuration or it's somehow not connecting as a superuser when you
think it is.
Is it possible that you somehow did a part of the replication setup as
the unprivileged user? Did you do any ALTER statements after you set up
replication?
Regards,
Jeff Davis
_______________________________________________
Slony1-general mailing list
[email protected]
http://gborg.postgresql.org/mailman/listinfo/slony1-general
