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.
