Chris Browne <cbbrowne@xxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
