| From: | Russell Smith <mr-russ(at)pws(dot)com(dot)au> |
|---|---|
| To: | PostgreSQL-Bugs <pgsql-bugs(at)postgresql(dot)org> |
| Subject: | PostgreSQL 8.4 - dumping database connection privileges |
| Date: | 2010-05-01 09:31:51 |
| Message-ID: | 4BDBF507.5030006@pws.com.au |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
Hi,
I've recently upgraded to PostgreSQL 8.4 as Redhat had begun supporting
it. I have tried to dump database grants, but have only found an
obscure way to do it.
I would expect;
postgres$ pg_dump -Fc database_name > backup.pgdump
would include all of the GRANT CONNECT on database_name TO "Role";
commands. It does not.
Second I tried;
postgres$ pg_dumpall -g > globals.sql
This also did not produce any GRANT CONNECT statements.
The only method I found that works is;
postgres$ pg_dumpall -s | grep 'ON DATABASE'
This method is not exactly fool proof and isn't what I expected to have
to do.
Is this considered a bug that the only way to do a dump/restore with
database privileges is to use pg_dumpall? I expect that pg_dump of a
database would include all of that information. I would argue it is at
least a misfeature and difficult for even an experienced user to understand.
Regards
Russell
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Haas | 2010-05-01 11:34:50 | Re: BUG #5444: Database Backup Restore - Out of memory problem |
| Previous Message | Martin Pitt | 2010-05-01 08:45:10 | Re: [9.0beta5/cvs head] build failure due to unchecked results |