pg_dump dumping out some irrelevant grants
| От | Chris Browne |
|---|---|
| Тема | pg_dump dumping out some irrelevant grants |
| Дата | |
| Msg-id | 871vohwttj.fsf@dba2.int.libertyrms.com обсуждение исходный текст |
| Ответы |
Re: pg_dump dumping out some irrelevant grants
|
| Список | 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@lucid.com
В списке pgsql-admin по дате отправления: