Re: PostgreSQL 8.4 - dumping database connection privileges - Mailing list pgsql-bugs

From Tom Lane
Subject Re: PostgreSQL 8.4 - dumping database connection privileges
Date
Msg-id 3367.1272728217@sss.pgh.pa.us
Whole thread Raw
In response to PostgreSQL 8.4 - dumping database connection privileges  (Russell Smith <mr-russ@pws.com.au>)
Responses Re: PostgreSQL 8.4 - dumping database connection privileges  (Russell Smith <mr-russ@pws.com.au>)
List pgsql-bugs
Russell Smith <mr-russ@pws.com.au> writes:
> Is this considered a bug that the only way to do a dump/restore with
> database privileges is to use pg_dumpall?

No, that's the intended place for them given the current division of
labor between pg_dump and pg_dumpall.  There have been complaints before
about this, but no one has proposed a better approach (where better
means "fixes this without breaking use-cases that work now").

            regards, tom lane

pgsql-bugs by date:

Previous
From: Robert Haas
Date:
Subject: Re: BUG #5444: Database Backup Restore - Out of memory problem
Next
From: Martin Pitt
Date:
Subject: Re: [9.0beta5/cvs head] build failure due to unchecked results