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

From Russell Smith
Subject Re: PostgreSQL 8.4 - dumping database connection privileges
Date
Msg-id 4BDD0116.5050806@pws.com.au
Whole thread Raw
In response to Re: PostgreSQL 8.4 - dumping database connection privileges  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: PostgreSQL 8.4 - dumping database connection privileges
List pgsql-bugs
On 02/05/10 01:36, Tom Lane wrote:
> 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
>
I have just spent an hour searching the archives and have been unable to
find any discussions on this issue.  I must be searching the wrong
terms.  Any ideas?  I would like to discuss this further, but it's a
little futile without reading the background material.

Also are use-cases that work now covered in the previous discussions,
I'd like to know what they are.

Regards

Russell

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: CVS build problem - make world target
Next
From: Tom Lane
Date:
Subject: Re: PostgreSQL 8.4 - dumping database connection privileges