> In that case you do "pg_dumpall -r" first and then pg_dump your
> individual database. I thought you were looking for something that
> would dump only roles referenced in the particular database, which
> is why it sounded like an intermediate case.
>
> I know that the division of labor between pg_dumpall and pg_dump could
> use rethinking, but it needs to be actually rethought, in toto, not
> hacked one minor feature at a time.
Sure. Maybe I should start a wiki page for that?
--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com