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 [email protected] 785-727-1171 > On Sep 3, 2020, at 6:01 PM, Lim, Justin <[email protected]> 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 > [email protected] > https://bucardo.org/mailman/listinfo/bucardo-general
signature.asc
Description: Message signed with OpenPGP
_______________________________________________ Bucardo-general mailing list [email protected] https://bucardo.org/mailman/listinfo/bucardo-general
