Re: Dumping roles improvements? - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Dumping roles improvements?
Date
Msg-id 201110111947.p9BJlBx00694@momjian.us
Whole thread Raw
In response to Re: Dumping roles improvements?  (Josh Berkus <josh@agliodbs.com>)
Responses Re: Dumping roles improvements?  (Josh Berkus <josh@agliodbs.com>)
List pgsql-hackers
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. +


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Intermittent regression test failure from index-only scans patch
Next
From: Tom Lane
Date:
Subject: Re: Range Types - typo + NULL string constructor