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
Last activity: Mar 6, 2016, 04:12 AM