Gilles Darold <gilles.dar...@dalibo.com> writes: > In the same query there is another bug introduced by commit 491c029 > that add Row-Level Security Policies. Current master code has a broken > pg_dumpall when trying to dump from a backend lower than 8.1.
Actually, I think that code is not just under-tested but poorly thought out. It will dump ALL roles from a pre-9.5 database with NOBYPASSRLS; even superusers. I would think that existing superusers ought to be assumed to have the BYPASSRLS property, no? (This assumes that the property means anything at all for superusers, which maybe it doesn't; but if so we probably ought to be forcing it true for superusers to avoid confusion.) regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers