Re: Dumping roles improvements?

Josh Berkus wrote:
> 
> > What is the logic for not dumping passwords but the CREATE ROLE
> > statement?  I don't see how anyone would recognize that behavior as
> > logical.  If you want to add a --no-passwords option to pg_dumpall, that
> > seems more logical to me.
> 
> That's what I'm suggesting.
> 
> Incidentally, what's the difference between -g and -r in terms of actual
> output, anyway?

Acording the docs, I assume -r is only roles, while -g includes
tablespace, so what you want is already available in pg_dumpall.

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + It's impossible for everything to be true. +