Sample Header Ad - 728x90

Postgres Row Level Security and BDR

1 vote
1 answer
368 views
I am implementing a multi tenant web app using postgres. I want to use Row Level Security (RLS ) for data separation. RLS is available from PG version 9.5. However, at the same time, the HA / DR teams plan to use BDR ( Bi directional replication) for the HA solution. It seems that BDR is not yet supported in 9.5. - What can be done in such a scenario ? - Is it possible to get BDR on 9.5 ? - What other replication strategies provide the same benefits as BDR? Yes, schemas is also an approach, but I am already using that for tables which have less data. I want RLS for tables that will eventually get enormous, so replicating them in different schemas wont be ideal.
Asked by InsatiableTraveller (111 rep)
Mar 1, 2016, 08:04 AM
Last activity: Mar 6, 2016, 04:12 AM