Probably your SA forgot to install PostgreSQL dev packages? I saw similar complains in the list:
http://archives.postgresql.org/pgsql-bugs/2009-09/msg00286.php -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp > No, I don't see libdl.so listed with ldd command. What should I do ? > I think our SA installed the 8.4.4 from the Mandriva rpm without > building it > from scratch. Is this the problem ? > > 9:15am 3 g...@nppdist:~> ldd /usr/local/pgsql/lib/libpq.so.5 > linux-gate.so.1 => (0xffffe000) > libcrypt.so.1 => /lib/libcrypt.so.1 (0x4014c000) > libc.so.6 => /lib/i686/libc.so.6 (0x4017a000) > /lib/ld-linux.so.2 (0x80000000) > > Thanks, > Gary > > What does ldd show against libpq? > > Mine is: > > > > $ ldd /usr/local/pgsql/lib/libpq.so.5 > > linux-gate.so.1 => (0xffffe000) > > libssl.so.4 => /lib/libssl.so.4 (0xb7f4c000) > > libcrypto.so.4 => /lib/libcrypto.so.4 (0xb7e43000) > > libcrypt.so.1 => /lib/libcrypt.so.1 (0xb7e15000) > > libc.so.6 => /lib/i686/libc.so.6 (0xb7cf3000) > > libdl.so.2 => /lib/libdl.so.2 (0xb7cef000) > > /lib/ld-linux.so.2 (0x80000000) > > > > Do you have libdl.so shown? > > -- > > Tatsuo Ishii > > SRA OSS, Inc. Japan > > English: http://www.sraoss.co.jp/index_en.php > > Japanese: http://www.sraoss.co.jp > > > > > >> After upgraded postgresql from 8.4.2 to 8.4.4, I have problem to run the > >> pgool II 2.3.3 with the following error message: > >> > >> /pgpool: symbol lookup error: /usr/local/pgsql/lib/libpq.so.5: undefined > >> symbol: dlopen > >> > >> When I tried to rebuild the pgpool II 2.3.3, the 'configure' failed with > >> the following message: > >> configure:24789: result: no > >> configure:24799: error: libpq is not installed or libpq is old > >> > >> In the 'config.log' file, I found the following message: > >> > >> configure:24727: checking for PQexecPrepared in -lpq > >> configure:24757: gcc -o conftest -g -O2 -Wall -Wmissing-prototypes > >> -Wmissing-declarations -L/home/gfu/pgpool2/tmp_lib conftest.c -lpq > >> -lcrypt -lresolv -lnsl -lm >&5 > >> /home/gfu/pgpool2/tmp_lib/libpq.so: undefined reference to `dlsym' > >> /home/gfu/pgpool2/tmp_lib/libpq.so: undefined reference to `dlerror' > >> /home/gfu/pgpool2/tmp_lib/libpq.so: undefined reference to `dladdr' > >> /home/gfu/pgpool2/tmp_lib/libpq.so: undefined reference to `dlopen' > >> /home/gfu/pgpool2/tmp_lib/libpq.so: undefined reference to `dlclose' > >> collect2: ld returned 1 exit status > >> configure:24763: $? = 1 > >> configure: failed program was: > >> | /* confdefs.h. */ > >> | > >> | #define PACKAGE_NAME "" > >> | #define PACKAGE_TARNAME "" > >> | #define PACKAGE_VERSION "" > >> | #define PACKAGE_STRING "" > >> > >> > >> Does anyone know what's the problem and how to resolve it ? > >> > >> Thanks, > >> Gary > >> > >> > >> > >> > >> _______________________________________________ > >> Pgpool-general mailing list > >> [email protected] > >> http://pgfoundry.org/mailman/listinfo/pgpool-general > >> > _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
