[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.


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

-------------- 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