Reply-To: <Jeff@PointHere.net>
From: "Jeffrey Brower" <Jeff@PointHere.net>
To: "'D'Arcy J.M. Cain'" <darcy@druid.net>
Cc: <pgsql-performance@postgresql.org>
References: <501201c808e4$06e0a350$1602a8c0@warpcore>
	<20071007164457.81f59d1d.darcy@druid.net>
Subject: Re: Apache2 PostgreSQL http authentication
Date: Sun, 7 Oct 2007 16:58:29 -0400
Organization: Green Visor, Inc.
Message-ID: <519f01c80924$cfed09b0$1602a8c0@warpcore>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="US-ASCII"
Content-Transfer-Encoding: 7bit
In-Reply-To: <20071007164457.81f59d1d.darcy@druid.net>
Thread-Index: AcgJI6UwMy+CI78xQgGUHuZbaIHGlAAAI3GA

Using a cron task was my first thought.  Unfortunately, new users are given
a logon that they immediately use.  I thought about shelling out and
updating a password file on an on-demand basis but I am not sure if that is
such a great idea either - especially since users can change their passwords
and renew their logons at will as well.

   Jeff
 

-----Original Message-----
From: D'Arcy J.M. Cain [mailto:darcy@druid.net] 
Sent: Sunday, October 07, 2007 4:45 PM
To: Jeff@PointHere.net
Cc: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Apache2 PostgreSQL http authentication

On Sun, 7 Oct 2007 09:14:43 -0400
"Jeffrey Brower" <Jeff@PointHere.net> wrote:
> As I say, from a performance point of view, I would really like to 
> know if there is anything I can do to make sure that postgres is 
> performing as quickly as possible under apache2 so that my http 
> authentication is not impacted too significantly.

How often does the user information change?  Can you simply create standard
Apache password files from cron during non-busy hours?
Sometimes the lower tech solution works best.

-- 
D'Arcy J.M. Cain <darcy@druid.net>         |  Democracy is three wolves
http://www.druid.net/darcy/                |  and a sheep voting on
+1 416 425 1212     (DoD#0082)    (eNTP)   |  what's for dinner.