On 02/09/2016 12:28 PM, Stephen Frost wrote:
JD,

* Joshua D. Drake (j...@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.

Just to be clear, what I was suggesting is that pg_dump would just work (and RLS would properly execute) or in other words, I shouldn't have to tell pg_dump to enable row security else throw an error. If RLS is enabled, then the backup just runs with appropriate permissions.

Or am I missing something?

Sincerely,

JD



Thanks!

Stephen



--
Command Prompt, Inc.                  http://the.postgres.company/
                        +1-503-667-4564
PostgreSQL Centered full stack support, consulting and development.
Everyone appreciates your honesty, until you are honest with them.


--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to