[Bucardo-general] Impact of disabling setting of "session replication role"

Mohan Krishnan mohangk at gmail.com
Tue Dec 22 08:12:32 UTC 2020


We are trying to use Bucardo on Google Cloud SQL Postgresql which does not
support setting of the "session replication role" by any user other than
the superuser and there is no way to create a superuser that can be used by
Bucardo. Both the source and target databases are GCSQL instances and hence
have this limitation.

Reading through this
https://www.endpoint.com/blog/2015/01/28/postgres-sessionreplication-role -
is my understanding that the session replication role is primarily used to
disable triggers and foreign key constraints on the target database? It
serves no purpose on the source database?

If that is the case, assuming that the  database schema that we are
replicating has no triggers or foreign key constraints , would disabling
the code path in Bucardo that sets the "session replication role" have any
impact on the actual replication process?

Any guidance on this would be much appreciated, thank you

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://bucardo.org/pipermail/bucardo-general/attachments/20201222/ca54831f/attachment.htm>

More information about the Bucardo-general mailing list