Re: Dumping roles improvements?

On 10/12/2011 03:16 PM, Josh Berkus wrote:
> On 10/11/11 9:43 PM, Tom Lane wrote:
>> I don't find this terribly convincing.  I can see the rationales for two
>> endpoint cases: (1) restore these objects into exactly the same
>> ownership/permissions environment that existed before, and (2) restore
>> these objects with the absolute minimum of ownership/permissions
>> assumptions.  The latter case seems to me to be covered already by
>> --no-owner --no-privileges.
> But what I'm asking for is (1).  The problem is that the roles don't
> ship in the per-database pgdump file.
>

I think Tom's (1) assumes you already have that environment, not that it 
will be created on the fly by pg_restore.

cheers

andrew