Re: pg_dumpall does not save CREATE permission on databases - Mailing list pgsql-bugs

From Tom Lane
Subject Re: pg_dumpall does not save CREATE permission on databases
Date
Msg-id 13699.1068494478@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_dumpall does not save CREATE permission on databases  (Neil Conway <neilc@samurai.com>)
Responses Re: pg_dumpall does not save CREATE permission on databases  (Neil Conway <neilc@samurai.com>)
List pgsql-bugs
Neil Conway <neilc@samurai.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

pgsql-bugs by date:

Previous
From: Neil Conway
Date:
Subject: Re: pg_dumpall does not save CREATE permission on databases
Next
From: Neil Conway
Date:
Subject: Re: pg_dumpall does not save CREATE permission on databases