[Bucardo-general] Superuser requirement for Bucardo

[David Christensen]

Hi Justin, is this on RDS by chance?

Bucardo required the ability to set session_replication_role for replication to work, which is generally only allowed to superusers, though RDS has an explicit permission for this and I wouldn’t be surprised if in later versions of PostgreSQL there was an allowed pg_* role that lets you set this.  (Hand-waving the details for RDS, since I don’t remember offhand, but I do recall this was allowed to work since RDS 9.4ish.)

The session_replication_role is actually only used on the target (though in a multimaster configuration, all nodes are targets).  There may be other pieces that I’m not remembering offhand that would be required in the source database, but it seems at least feasible for unidirectional data replication to not require this on the source.

It would probably take patches to support this, since if it worked that way already you wouldn’t be writing. :-)

Best,

David
--
David Christensen
Senior Software and Database Engineer
End Point Corporation
david at endpoint.com
785-727-1171


> On Sep 3, 2020, at 6:01 PM, Lim, Justin <justlim at amazon.com> wrote:
> 
> Hello,
> 
> I am trying to use Bucardo to replicate from a database that does not allow me superuser permissions. With Bucardo, this is required to be used on the source/target database.
> 
> Is there any workaround for this, especially on the source database?
> 
> --
> Thanks,
> 
> Justin
> _______________________________________________
> Bucardo-general mailing list
> Bucardo-general at bucardo.org
> https://bucardo.org/mailman/listinfo/bucardo-general

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 833 bytes
Desc: Message signed with OpenPGP
URL: <https://bucardo.org/pipermail/bucardo-general/attachments/20200904/8e94dfff/attachment.sig>