I had the same problem, and that's why I got here ).
I didn't find the solution but some clues.. First I thought it was due to access rights related to the interprocess comms between Apache, perl and the CGI stuff, and lost some time figuring out what was wrong there
some hours later (don't ask me how) I've found out that the problem was related to some other very diffrent and unbelievablely related foolish fact : the fact I realized I have a multithreaded MPM.
You'll may be asking what it has to do.. (me too ;-)). looking at the ref: http://httpd.apache.org/docs/2.2/mod/mod_cgi.html, Ive learned that: "When using a multi-threaded MPM under unix, the module mod_cgid should be used in place of this module " (was talking about mod_cgi (note de 'd')). "At the user level,...modules are essentially identical..."
I decided to add the module,
and voila ...(:P)
(I hope it helps you not to waste the time I spent. if it helps you send me just a line for Christmas)
best regards.

ps: I guess, it also may be important were/how to add the config line. I've put it in between this condition. (with a comment to remember the event :-)
< IfModule worker.c >
LoadModule cgid_module modules/mod_cgid.so
# added by FSFB 20061118 to solve the DBDPg affaire: DBI connect('dbname=UYLN03; host=192.168.0.13; # port=9555; ','postgres',...) failed: could not create socket: Permission denied
</IfModule>
Franco