Hello,
I had a question regarding using PostgreSQL as the authorization database for Apache. Previously I was using Apache authentication module for MySQL v2.20 (mod_auth_mysql) and was wondering if there was an equivalent module for use with PostgreSQL?
I must add I'm really impressed with the responsiveness of the 7.0.3 PostgreSQL under decent load from my java servers. Replacing my "left joins" with subselects and keeping the temporary tables (you have to use them in mysql in a lot of cases), I see quite a number of performance increases or about-the-same query times. I'm not a benchmarking type of guy, just have a feel for "seems slower, seems faster, seems-about-the-same". Very cool. Plus, the original reason I switched (something very very strange with multiple threads pounding the JDBC driver and/or transient temporary table collisions corrupting query constructs and updates) seems all but last week's headache (fingers crossed).
Thanks,
George