| From: | Chris Browne <cbbrowne(at)acm(dot)org> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | pg_dump dumping out some irrelevant grants |
| Date: | 2009-07-15 20:54:32 |
| Message-ID: | 871vohwttj.fsf@dba2.int.libertyrms.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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;
The problem isn't anything terribly deep - it's just that there is no
user "chris" in their environment (chris happens to be one of the
superuser accounts on my workstation ;-)), so that the REVOKE/GRANT
combination raises errors.
Note that:
- I used the "postgres" superuser for anything needing superuserness
- I decline to use "sed" to filter this out; see the .sig ;-)
Is this an artifact of the fact that "chris" is the 'base superuser'?
--
output = ("cbbrowne" "@" "linuxfinances.info")
http://cbbrowne.com/info/postgresql.html
"Some people, when confronted with a Unix problem, think ‘I know, I’ll
use sed.’ Now they have two problems." - jwz(at)lucid(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Anj Adu | 2009-07-15 21:58:00 | commit within function |
| Previous Message | Anj Adu | 2009-07-15 19:18:01 | Re: out of memory for query, partitioning & vacuuming |