Jimmy Angelakos

Row-Level Security (RLS) in PostgreSQL is awesome, as it allows you to isolate each user or tenant's data, lock it down and default to "deny access"... but it sucks because it makes assumptions about your application that are not applicable in many cases.

Especially if your applications were developed without RLS in mind and you use a single app user to connect to the database, it's impossible to use RLS in any meaningful way.

In this talk, we'll look at possible ways to roll out RLS that can let you take advantage of this powerful feature in the real world.

Various PostgreSQL community members attend SCaLE and are willing to meet with attendees and answer any questions. Many aspects of the community are covered: User groups, conference organization, core development, exhibitions, advocates and more! Please come and ask any questions!

Company database holding critical data goes down after a hard disk crash. There is no redundancy, and no usable backups. The only thing that remains is just a list of files with no structure, recovered from the destroyed filesystem. There is intense time pressure to get back online, and no clear path forward.