Forum OpenACS Q&A: Postgres driver and libpthread (HP-UX)

On my HPUX 11.0 machine, Postgres 7.0.3 compiles and runs fine. It is also happy with the OpenACS data model; I can go to psql and see all the tables, add rows, etc.

To link the postgres driver, I used this command (as per David Chin in another thread):

ld -b -o postgres.sl postgres.o /usr/local/pgsql/lib/libpq.sl
The driver links fine, but when loading, it complains of two unresolved symbols -- __pthread_create_system and __pthread_attr_init_system. When I try to link against the libpthread library (by adding a "-lpthread" to the above command), shl_load cannot load it because libpthread has Thread Local Storage (as explained on the Oracle Driver documentation page ).

The solution for the Oracle driver was to generate a version of the Oracle client library that does not link against libctl and libpthread. I tried to grep through the pgdriver and postgres directories, and couldn't figure out where the libpthread dependency comes from. Can someone please help?

Thanks,