Re: Multi-tenancy with RLS - Mailing list pgsql-hackers

From Robert Haas
Subject Re: Multi-tenancy with RLS
Date
Msg-id CA+TgmobJVKkfA7PQ9pTywz91McwMA67j0g1KHxZhUi+u4p6yEw@mail.gmail.com
Whole thread Raw
In response to Re: Multi-tenancy with RLS  (Stephen Frost <sfrost@snowman.net>)
Responses Re: Multi-tenancy with RLS
List pgsql-hackers
On Tue, Feb 9, 2016 at 3:28 PM, Stephen Frost <sfrost@snowman.net> wrote:
> JD,
>
> * Joshua D. Drake (jd@commandprompt.com) wrote:
>> pg_dump -U $non-super_user
>>
>> Should just work, period.
>
> That ship has sailed already, where you're running a pg_dump against
> objects you don't own and which have RLS enabled on them.

But you'll get an error rather than an incomplete dump, and you won't
run some code that you didn't want to run.  Those distinctions matter.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Multi-tenancy with RLS
Next
From: Andrew Dunstan
Date:
Subject: Re: Tracing down buildfarm "postmaster does not shut down" failures