Are there any good examples of proper connection threadpool configuration available?
I've looked at http://openacs.org/forums/message-view?message_id=1146218 and am a bit confused. (BTW this is not an OpenACS site, just plain .adp pages). Thanks Alexey for the Ubuntu packages, before checking them out I'll try to get this latest AOLserver version just compiled to stay up :) /Björn 2010/11/18 Tom Jackson <[email protected]> > BTW, I don't think the issue you are seeing has anything to do with > the database pools, the problem is the connection threadpools (you are > using the default threadpool). > > tom jackson > > On Thu, Nov 18, 2010 at 8:42 AM, Alexey Pechnikov > <[email protected]> wrote: > > On my debian lenny/squeeze 32 and 64 bit hosts this work fine with > > PostgreSQL 8.1/8.4: > > # Database drivers > > ns_section "ns/db/drivers" > > ns_param postgres nspostgres.so ;# An internal driver > > #ns_section "ns/db/driver/postgres" > > #ns_param pgbin /usr/lib/postgresql/8.1/bin/psql > > ns_section "ns/db/pools" > > ns_param maindb "Main database Pool" > > ns_param session "Session database Pool" > > ns_section "ns/db/pool/maindb" > > ns_param driver postgres > > ns_param datasource $env(PGHOST):$env(PGPORT):$env(PGDBNAME) > > ns_param user $env(PGUSER) > > ns_param password "" > > ns_param connections 20 > > ns_param logsqlerrors true ;# Verbose SQL query error logging > > ns_param verbose false ;# Verbose error logging > > ns_param maxidle 600 ;# Max time to keep idle db conn > open > > ns_param maxopen 3600 ;# Max time to keep active db conn > open > > ns_section "ns/db/pool/session" > > ns_param driver postgres > > ns_param datasource $env(PGHOST):$env(PGPORT):$env(PGDBNAME) > > ns_param user $env(PGUSER) > > ns_param password "" > > ns_param connections 20 > > ns_param logsqlerrors true ;# Verbose SQL query error logging > > ns_param verbose false ;# Verbose error logging > > ns_param maxidle 600 ;# Max time to keep idle db conn > open > > ns_param maxopen 3600 ;# Max time to keep active db conn > open > > # Accessing DB pools > > ns_section "ns/server/${servername}/db" > > ns_param pools * ;# Wildcard gives access to all > > ns_param defaultpool maindb > > > > You can try on Ubuntu packages aolserver4 and aolserver4-nspostgres from > my > > repository: > > > > deb http://mobigroup.ru/debian/ squeeze main non-free > > deb-src http://mobigroup.ru/debian/ squeeze main non-free > > > > -- > > Best regards, Alexey Pechnikov. > > http://pechnikov.tel/ > > > > -- > > AOLserver - http://www.aolserver.com/ > > > > To Remove yourself from this list, simply send an email to > > <[email protected]> with the > > body of "SIGNOFF AOLSERVER" in the email message. You can leave the > Subject: > > field of your email blank. > > > > > -- > AOLserver - http://www.aolserver.com/ > > To Remove yourself from this list, simply send an email to < > [email protected]> with the > body of "SIGNOFF AOLSERVER" in the email message. You can leave the > Subject: field of your email blank. > -- Björn Þór Jónsson http://bthj.is -- AOLserver - http://www.aolserver.com/ To Remove yourself from this list, simply send an email to <[email protected]> with the body of "SIGNOFF AOLSERVER" in the email message. You can leave the Subject: field of your email blank.
