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(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +