On Fri, 20 Jun 1997, Martin J. Laubach wrote:
> > What about user profiles stored in database in system pg_profile
> > table ? We live in virtual world...
>
> Yes, but I may need different .psqlrc for different databases.
> I'd say
>
> - global rc file (maybe in a pg_profile table)
> - user settings (~/.pgrc, or maybe in the database too?)
> - extra user settings (./.pgrc, or specified on command line)
Take a look at the gated.conf/named.conf files...they have it
setup so that you have {}'d configuration sections...
Why not something that goes:
settings database1 {
options here
}
settings database2 {
option here
}
etc
One config file, many directives...
hell, while we are at it, why not go one step further and add an
option from that file to do the security on a per-database basis...oops,
nope, that would have to be in the pg_profile, where the owner could setup
'access privileges' like is in pg_hba.conf without having to bother the
superuser?
Marc G. Fournier scrappy@hub.org
Systems Administrator @ hub.org scrappy@freebsd.org
------------------------------
