[pgpool-general: 1909] pcp_attach_node: error while loading shared libraries: libpcp.so.0: cannot open shared object file: No such file or directory

[Nathan Brennan]

Hi,

I've been playing around with the master/slave streaming replication and I
went to re-attach a failed node but I was unable to use pcp_attach_node.

I am using:
- pgpool-II-3.3.0-beta1
- ubuntu 12.04 LTS
- postgresql 9.1 ( separate server to pgpool )

The ubuntu install which has pgpool on it is basically a clean with only
the following installed:
- postgresql-client-9.1
- build-essential
- libpq-dev

pgpool installation:
- ./configure
- make
- sudo make install

Not really sure what's happened here but the libraries don't seem to be
linked

root at ip-10-0-0-150:/usr/local/bin# ldd pcp_attach_node
        linux-vdso.so.1 =>  (0x00007fff455d5000)
        libpcp.so.0 => not found
        libc.so.6 => /lib/x86_64-linux-gnu/libc.so.6 (0x00007f9d854d5000)
        /lib64/ld-linux-x86-64.so.2 (0x00007f9d8589b000)

root at ip-10-0-0-150:/usr/local/bin# ldd pgpool
        linux-vdso.so.1 =>  (0x00007fff1049f000)
        libpq.so.5 => /usr/lib/libpq.so.5 (0x00007f4f31ccf000)
        libpcp.so.0 => /usr/local/lib/libpcp.so.0 (0x00007f4f31ac7000)
        libpthread.so.0 => /lib/x86_64-linux-gnu/libpthread.so.0
(0x00007f4f318a4000)
        libcrypt.so.1 => /lib/x86_64-linux-gnu/libcrypt.so.1
(0x00007f4f3166b000)
        libc.so.6 => /lib/x86_64-linux-gnu/libc.so.6 (0x00007f4f312ac000)
        libssl.so.1.0.0 => /lib/x86_64-linux-gnu/libssl.so.1.0.0
(0x00007f4f3104d000)
        libcrypto.so.1.0.0 => /lib/x86_64-linux-gnu/libcrypto.so.1.0.0
(0x00007f4f30c72000)
        libkrb5.so.3 => /usr/lib/x86_64-linux-gnu/libkrb5.so.3
(0x00007f4f309a4000)
        libcom_err.so.2 => /lib/x86_64-linux-gnu/libcom_err.so.2
(0x00007f4f3079f000)
        libgssapi_krb5.so.2 =>
/usr/lib/x86_64-linux-gnu/libgssapi_krb5.so.2 (0x00007f4f30561000)
        libldap_r-2.4.so.2 => /usr/lib/x86_64-linux-gnu/libldap_r-2.4.so.2
(0x00007f4f30312000)
        /lib64/ld-linux-x86-64.so.2 (0x00007f4f31efd000)
        libdl.so.2 => /lib/x86_64-linux-gnu/libdl.so.2 (0x00007f4f3010d000)
        libz.so.1 => /lib/x86_64-linux-gnu/libz.so.1 (0x00007f4f2fef6000)
        libk5crypto.so.3 => /usr/lib/x86_64-linux-gnu/libk5crypto.so.3
(0x00007f4f2fcce000)
        libkrb5support.so.0 =>
/usr/lib/x86_64-linux-gnu/libkrb5support.so.0 (0x00007f4f2fac5000)
        libkeyutils.so.1 => /lib/x86_64-linux-gnu/libkeyutils.so.1
(0x00007f4f2f8c1000)
        libresolv.so.2 => /lib/x86_64-linux-gnu/libresolv.so.2
(0x00007f4f2f6a5000)
        liblber-2.4.so.2 => /usr/lib/x86_64-linux-gnu/liblber-2.4.so.2
(0x00007f4f2f496000)
        libsasl2.so.2 => /usr/lib/x86_64-linux-gnu/libsasl2.so.2
(0x00007f4f2f27b000)
        libgssapi.so.3 => /usr/lib/x86_64-linux-gnu/libgssapi.so.3
(0x00007f4f2f03d000)
        libgnutls.so.26 => /usr/lib/x86_64-linux-gnu/libgnutls.so.26
(0x00007f4f2ed80000)
        libgcrypt.so.11 => /lib/x86_64-linux-gnu/libgcrypt.so.11
(0x00007f4f2eb02000)
        libheimntlm.so.0 => /usr/lib/x86_64-linux-gnu/libheimntlm.so.0
(0x00007f4f2e8fa000)
        libkrb5.so.26 => /usr/lib/x86_64-linux-gnu/libkrb5.so.26
(0x00007f4f2e674000)
        libasn1.so.8 => /usr/lib/x86_64-linux-gnu/libasn1.so.8
(0x00007f4f2e3d4000)
        libhcrypto.so.4 => /usr/lib/x86_64-linux-gnu/libhcrypto.so.4
(0x00007f4f2e19f000)
        libroken.so.18 => /usr/lib/x86_64-linux-gnu/libroken.so.18
(0x00007f4f2df8a000)
        libtasn1.so.3 => /usr/lib/x86_64-linux-gnu/libtasn1.so.3
(0x00007f4f2dd79000)
        libp11-kit.so.0 => /usr/lib/x86_64-linux-gnu/libp11-kit.so.0
(0x00007f4f2db66000)
        libgpg-error.so.0 => /lib/x86_64-linux-gnu/libgpg-error.so.0
(0x00007f4f2d962000)
        libwind.so.0 => /usr/lib/x86_64-linux-gnu/libwind.so.0
(0x00007f4f2d739000)
        libheimbase.so.1 => /usr/lib/x86_64-linux-gnu/libheimbase.so.1
(0x00007f4f2d529000)
        libhx509.so.5 => /usr/lib/x86_64-linux-gnu/libhx509.so.5
(0x00007f4f2d2df000)
        libsqlite3.so.0 => /usr/lib/x86_64-linux-gnu/libsqlite3.so.0
(0x00007f4f2d03c000)


Any ideas on how I can fix this ?

Thanks
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20130722/3e711e95/attachment.htm>