Re: Should SET ROLE inherit config params?

Josh Berkus <josh@agliodbs.com>

From: Josh Berkus <josh@agliodbs.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Robert Haas <robertmhaas@gmail.com>, Simon Riggs <simon@2ndQuadrant.com>, pgsql-hackers@postgresql.org
Date: 2009-03-27T17:00:42Z
Lists: pgsql-hackers
Tom,

> BTW, does pg_dumpall know to dump ALTER USER SET settings attached
> to built-in roles (such as the proposed "autovacuum" role)?  I'd bet
> it doesn't do that.  Even if it does, that seems like a more awkward
> way to push settings over to a new installation than copying your
> postgresql.conf file.
>
> Simon's idea of "profiles" sounds worth pursuing to me, but clearly
> it's not happening for 8.4.

I don't see why having a *separate* concept of profiles in addition to 
the ROLES is helpful.  It seems like building a whole new house when all 
we really need is to expand the garage.

--Josh