FreeBSD pl/java problem : backend hangs

Achilleas Mantzios achill at matrix.gatewaynet.com
Tue Feb 5 08:38:22 UTC 2013


On ΔεÏ
 04 Φεβ 2013 19:18:59 you wrote:

> Try to start the postgres daemon with 'LD_PRELOAD=/lib/libthr.so.3'
> env variable set.

Thanx, i tried with this, inside postgresql startup script with no luck.
I also saw this thread here : http://www.postgresql.org/message-id/68c429ede4cde3874b37460b5b1d4aaf@cs.helsinki.fi
(but could not find its continuation over the FreeBSD camp)
The author claims that postgres backend executable must be linked with -lpthread.
Inside postgres's Makefile.global i can see 
PTHREAD_CFLAGS         =  -pthread  -D_REENTRANT -D_THREAD_SAFE -D_POSIX_PTHREAD_SEMANTICS
THREAD_LIBS           =  -lpthread
however when i do 

root at smadev:/usr/local/src/postgresql-9.2.2# ldd /usr/local/pgsql/bin/postgres
/usr/local/pgsql/bin/postgres:
        libm.so.5 => /lib/libm.so.5 (0x800ae5000)
        libldap-2.4.so.8 => /usr/local/lib/libldap-2.4.so.8 (0x800c05000)
        libc.so.7 => /lib/libc.so.7 (0x800d47000)
        liblber-2.4.so.8 => /usr/local/lib/liblber-2.4.so.8 (0x800f89000)
        libssl.so.6 => /usr/lib/libssl.so.6 (0x801096000)
        libcrypto.so.6 => /lib/libcrypto.so.6 (0x8011e9000)

i see nothing thread (libpthread or libtrh) related.

Any help to overcome this much appreciated.

> 
> > 

-
Achilleas Mantzios
IT DEV
IT DEPT
Dynacom Tankers Mgmt


More information about the freebsd-java mailing list