Openser installation problem with postgres

Using Openser on Redhat ES4.0.
Postgres 8.1.3 was installed post Linux install (put into /usr/local/pgsql).
Following openser installation, we have error when starting openser:
I get "ERROR:core:sr_load_module: could not open module </usr/local/lib/openser/modules/>: /usr/local/lib/openser/modules/ undefined symbol: PQescapeByteaConn"
My postgres installation is done outside of the distro installation. I do not see an option to help the configure / make process find the actual pqxx lib and the pgsql install locations...I assume it found them, but maybe not. openserdbctl worked perfectly.
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

http:// thevpn.guruConnect With a Mentor Commented:
I get "ERROR:core:sr_load_module: could not open module </usr/local/lib/openser/modules/>: /usr/local/lib/openser/modules/

you have compiled OpenSer without postgres the MakeFile you will find an exlude_modules option delete the postgres option from that option then make all then make install and try again.
JerryNortonAuthor Commented:
That was a likely culprit, but I actually did change the Makefile and compile (it says to do this in the instructions, so I wasn't being all that clever).
In /usr/local/lib/modules there is a
If I do: strings | grep PQ I see
%s [%d] ERROR:postgres:%s: PQescapeBytea failed
(along with the other usual suspects).

gheistConnect With a Mentor Commented:
The problem is "Postgres 8.1.3 was installed post Linux install (put into /usr/local/pgsql)"
Install redhat's rpm and every ./configure will catch up.
JerryNortonAuthor Commented:
Thanks everyone. Problem found to be openser needed the most recent from postgres, found in 8.2.x. Installing from rpm wouldn't help (redhat behind on that front). Also, am I the only person that has systems with interdependencies? everyone seems to be willing to upgrade without worrying about compatibility ... regression testing ... etc.

Am splitting the points but if anyone reads this, note that the solution is not quite here. As i could not fiind anywhere on openser's site that includes a required revision level for any module.
JerryNortonAuthor Commented:
Thanks for trying
All Courses

From novice to tech pro — start learning today.