Segfaults with mod_perl are often a result of using a mod_perl and perl libraries compiled with different versions of Perl. I'd suggest you compile Apache, mod_perl, and the DBI/PostgreSQL modules from source. It's a pain, but it will probably fix this.