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