I got bit by this one, too, initially.
Don't put the postgres module definition under "ns/drivers".
Instead, put it under:
ns_section "ns/db/drivers" ns_param postgres nspostgres.so
That should fix the problem.