Thanks for the reply! I have used this in the past on Linux systems with Apache 1 - but I had no idea if the Apache2 version would compile under Solaris (let alone the Solaris X86 version) and run dependably. I sent Giuseppe an email and asked him, but I've gotten no reply. It looks like it had been a while since his system was updated (the version for apache2 was last updated in January of 2006) but that could easily be a testament to its solid performance since then. Thank you for letting me know that someone is actually using it under Solaris 10 X86 and that it will work dependably. I have heard tale of failures using the apache supplied module so this makes me happy. I will post my results here. Thanks again! Jeff -----Original Message----- From: pgsql-performance-owner@xxxxxxxxxxxxxx [mailto:pgsql-performance-owner@xxxxxxxxxxxxxx] On Behalf Of A.M. Sent: Sunday, October 07, 2007 11:20 AM To: pgsql-performance@xxxxxxxxxxxxxx Subject: Re: Apache2 PostgreSQL http authentication On Oct 7, 2007, at 9:14 , Jeffrey Brower wrote: > Greetings All, > > I have to authenticate against an existing (constantly modified) > PostgreSQL database under Solaris 10 (X86). While my PHP scripts are > an obvious no-brainer, the rest of the contents need to be protected > as well (images, > etc) so the http authentication is required. I am using the blastwave > Apache2 and PostgreSQL packages. I found it trivial to install mod_auth_pgsql. http://www.giuseppetanzilli.it/mod_auth_pgsql/ As far as performance, only your testing will tell if it is sufficient. In my setup, the authentication overhead is the least of my worries. Cheers, M ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
