Chris Browne <cbbrowne(at)acm(dot)org> writes:
> I'm finding that pg_dumps are dumping out, right near the end, the
> following sequence of grants that are causing our QA folk a little bit
> of concern:
> REVOKE ALL ON SCHEMA public FROM PUBLIC;
> REVOKE ALL ON SCHEMA public FROM chris;
> GRANT ALL ON SCHEMA public TO chris;
> GRANT ALL ON SCHEMA public TO PUBLIC;
> Is this an artifact of the fact that "chris" is the 'base superuser'?
Yup. If you're restoring into a system with a different base superuser
name, you'll just have to ignore those errors.
regards, tom lane