[Bucardo-general] permission denied to set parameter "session_replication_role"
jtkells
jtkells at verizon.net
Thu Mar 22 17:49:43 UTC 2012
On Thu, 22 Mar 2012 13:25:04 -0400
Greg Sabino Mullane <greg at endpoint.com> wrote:
> > I looked at the code and it appears to be talking about the
> > slave???? The slave account ( and the master account ) are normal
> > users. Do they need to be a superuser?
>
> Yes. Because of this parameter (and other reasons), every user
> mentioned in bucardo.db needs to be a superuser. Standard practice is
> to create a superuser named 'bucardo' for easier auditing.
>
Greg,
Thanks for your quick turnaround, I actually found a similar post on
2008 referencing this issue. I have created a bucardo account on the
slave as superuser and used bucardo for both the master and slave
database connections accounts. All seems to be working fine now
Thanks
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 198 bytes
Desc: not available
Url : https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20120322/bd9013f0/attachment.bin
More information about the Bucardo-general
mailing list