Re: pg_dumpall does not save CREATE permission on databases

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Neil Conway <neilc(at)samurai(dot)com>
Cc: Paul Tillotson <ptchristendom(at)yahoo(dot)com>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: pg_dumpall does not save CREATE permission on databases
Date: 2003-11-10 20:01:18
Message-ID: 13699.1068494478@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Neil Conway <neilc(at)samurai(dot)com> writes:
> Is this a candidate for being back-patched to 7_3_STABLE? IMHO it
> would be useful and low-risk.

Well, it was done as part of a significant set of changes to pg_dumpall:

2003-05-30 18:55 tgl

* src/bin/pg_dump/: dumputils.c, dumputils.h, pg_dump.c,
pg_dumpall.c: Cause pg_dumpall to include GRANT/REVOKE for
database-level permissions in its output. Make it work with server
versions back to 7.0, too.

I'm not sure what it would take to extract the "low risk" parts of that.

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Neil Conway 2003-11-10 20:17:08 Re: pg_dumpall does not save CREATE permission on databases
Previous Message Neil Conway 2003-11-10 19:49:11 Re: pg_dumpall does not save CREATE permission on databases