Chris Browne <cbbro...@acm.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
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
