Gilles Darold <gilles(dot)darold(at)dalibo(dot)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