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: | Raw Message | Whole Thread | 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 |