[Bucardo-general] Migrating to Amazon Postgres RDS

Greg Sabino Mullane greg at endpoint.com
Thu Mar 6 18:54:18 UTC 2014

On Wed, Mar 05, 2014 at 08:14:04AM -0800, Chris Keane wrote:
> I've asked the fine folks at Amazon to either
> (a) allow role rds_superuser to issue the SET session_replication_mode
> command; or
> (b) create a function with SECURITY DEFINER as a superuser that would SET
> session_replication_mode.
> Are there any other options. Any way you can think of to disable triggers
> for a single session without session_replication_mode?

No. You need session_replication_role, or you need to alter the system 
tables. Both need superuser access. The only way around is to use 
security definer, as you indicated above. You want to avoid modifying 
pg_class if at all possible. That way was ugly. :)

I don't think there is anything else offhand that needs superuser 
privs, but if you get (a) or (b) above, I'm sure you will be able 
to find out quick. :)

If they go with (b) we can modify Bucardo to conditionally call the function 
rather than the set.

Greg Sabino Mullane greg at endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 163 bytes
Desc: Digital signature
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20140306/9423508e/attachment-0001.sig>

More information about the Bucardo-general mailing list