Tom,
* Tom Lane (tgl@sss.pgh.pa.us) wrote:
> --role switch for pg_dump and pg_dumpall: sets the role used while
> dumping, has no effect on the emitted archive.
>
> --role switch for pg_restore: sets the role used while restoring,
> if it's to be different from what -U says.
As one of the original requestors for this capability, just wanted to
add my 2c that this will work for me and makes sense to me.
Thanks,
Stephen