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