I haven't fixed the problem yet. But I did appreciate your story. It gave me a few more ideas of things to try. I'm still hoping not to go on any more of a recompiling rampage than I already have. It tends to be a whack-a-mole type game.

I did try strace/truss/gdb, but nothing struck me as obvious.

I tried running from the command line and CGI very early in trying to solve this and forgot about the output. Which may be more useful because it probably means this isn't strictly a mod_perl issue.

Here is the error I get using CGI (non mod_perl): 

DBD::Pg::st execute failed: PQsendQuery() -- There is no connection to
+ the backend. at /usr/lib/perl5/site_perl/Apache/Session/Store/DBI.pm
+ line 65.

[download]
I think that if I can get this working under vanilla CGI, then mod_perl will work aswell.

Thanks for the help,
Staunch

In reply to Re: Re: Trouble with mod_perl, Apache::Session::Postgres, and DBI by staunch
in thread Trouble with mod_perl, Apache::Session::Postgres, and DBI by staunch

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.