Did you create your session table? This was a thing that
got me when I first used Apache::Session.
You can
see those docs with
perldoc Apache::Session::Store::Postgres
I would also recommend adding an additional timestamp field
to the table for future session deletion based on time, it
has come in handy for me.
Comment on Re: Trouble with mod_perl, Apache::Session::Postgres, and DBI
I created the session table the same as the docs specify.
And I am using a timestamp field (for expiration).
I didn't mention those things in my post in an attempt not
to distract from the problem.
If I open separate connections for DBI and Apache::Session::Postgres
I can use them both just fine.