Neil Conway wrote:
> On Thu, 2003-10-16 at 12:54, Josh Berkus wrote:
> > While one could write a utility in Postgres to create/process the file, the
> > "live" version of pg_hba.conf *must* be outside the database. If our ACL
> > was in the database, then how would we know who has the rights to read the
> > ACL?
> I don't see why this is a show-stopping problem. Can you elaborate?
We don't want to fire up a backend until we know this is a valid user.
You could easily bring a server to a standstill by just sending false
connection requests. Sure, you can still do that by flooding the
machine, but a database lookup is significantly more expensive than
checking a connection packet.
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
In response to
pgsql-advocacy by date
|Next:||From: Peter Eisentraut||Date: 2003-10-17 11:40:09|
|Subject: Re: Mapping Oracle types to PostgreSQL types|
|Previous:||From: Arcadius A.||Date: 2003-10-17 10:23:02|
|Subject: Re: MySQL interview, no mention of PostgreSQL|