<div dir="ltr">Hi,
<div><br></div><div>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.</div><div><br></div><div>I am using:</div><div>- pgpool-II-3.3.0-beta1</div>
<div>- ubuntu 12.04 LTS </div><div>- postgresql 9.1 ( separate server to pgpool )</div><div><br></div><div>The ubuntu install which has pgpool on it is basically a clean with only the following installed:</div><div>- postgresql-client-9.1</div>
<div>- build-essential</div><div>- libpq-dev</div><div><br></div><div>pgpool installation:</div><div><div>- ./configure</div><div>- make</div><div>- sudo make install</div></div><div><br></div><div>Not really sure what's happened here but the libraries don't seem to be linked</div>
<div><br></div><div><div>root@ip-10-0-0-150:/usr/local/bin# ldd pcp_attach_node</div><div> linux-vdso.so.1 => (0x00007fff455d5000)</div><div> libpcp.so.0 => not found</div><div> libc.so.6 => /lib/x86_64-linux-gnu/libc.so.6 (0x00007f9d854d5000)</div>
<div> /lib64/ld-linux-x86-64.so.2 (0x00007f9d8589b000)</div></div><div><br></div><div>root@ip-10-0-0-150:/usr/local/bin# ldd pgpool<br></div><div><div> linux-vdso.so.1 => (0x00007fff1049f000)</div><div> libpq.so.5 => /usr/lib/libpq.so.5 (0x00007f4f31ccf000)</div>
<div> libpcp.so.0 => /usr/local/lib/libpcp.so.0 (0x00007f4f31ac7000)</div><div> libpthread.so.0 => /lib/x86_64-linux-gnu/libpthread.so.0 (0x00007f4f318a4000)</div><div> libcrypt.so.1 => /lib/x86_64-linux-gnu/libcrypt.so.1 (0x00007f4f3166b000)</div>
<div> libc.so.6 => /lib/x86_64-linux-gnu/libc.so.6 (0x00007f4f312ac000)</div><div> libssl.so.1.0.0 => /lib/x86_64-linux-gnu/libssl.so.1.0.0 (0x00007f4f3104d000)</div><div> libcrypto.so.1.0.0 => /lib/x86_64-linux-gnu/libcrypto.so.1.0.0 (0x00007f4f30c72000)</div>
<div> libkrb5.so.3 => /usr/lib/x86_64-linux-gnu/libkrb5.so.3 (0x00007f4f309a4000)</div><div> libcom_err.so.2 => /lib/x86_64-linux-gnu/libcom_err.so.2 (0x00007f4f3079f000)</div><div> libgssapi_krb5.so.2 => /usr/lib/x86_64-linux-gnu/libgssapi_krb5.so.2 (0x00007f4f30561000)</div>
<div> libldap_r-2.4.so.2 => /usr/lib/x86_64-linux-gnu/libldap_r-2.4.so.2 (0x00007f4f30312000)</div><div> /lib64/ld-linux-x86-64.so.2 (0x00007f4f31efd000)</div><div> libdl.so.2 => /lib/x86_64-linux-gnu/libdl.so.2 (0x00007f4f3010d000)</div>
<div> libz.so.1 => /lib/x86_64-linux-gnu/libz.so.1 (0x00007f4f2fef6000)</div><div> libk5crypto.so.3 => /usr/lib/x86_64-linux-gnu/libk5crypto.so.3 (0x00007f4f2fcce000)</div><div> libkrb5support.so.0 => /usr/lib/x86_64-linux-gnu/libkrb5support.so.0 (0x00007f4f2fac5000)</div>
<div> libkeyutils.so.1 => /lib/x86_64-linux-gnu/libkeyutils.so.1 (0x00007f4f2f8c1000)</div><div> libresolv.so.2 => /lib/x86_64-linux-gnu/libresolv.so.2 (0x00007f4f2f6a5000)</div><div> liblber-2.4.so.2 => /usr/lib/x86_64-linux-gnu/liblber-2.4.so.2 (0x00007f4f2f496000)</div>
<div> libsasl2.so.2 => /usr/lib/x86_64-linux-gnu/libsasl2.so.2 (0x00007f4f2f27b000)</div><div> libgssapi.so.3 => /usr/lib/x86_64-linux-gnu/libgssapi.so.3 (0x00007f4f2f03d000)</div><div> libgnutls.so.26 => /usr/lib/x86_64-linux-gnu/libgnutls.so.26 (0x00007f4f2ed80000)</div>
<div> libgcrypt.so.11 => /lib/x86_64-linux-gnu/libgcrypt.so.11 (0x00007f4f2eb02000)</div><div> libheimntlm.so.0 => /usr/lib/x86_64-linux-gnu/libheimntlm.so.0 (0x00007f4f2e8fa000)</div><div> libkrb5.so.26 => /usr/lib/x86_64-linux-gnu/libkrb5.so.26 (0x00007f4f2e674000)</div>
<div> libasn1.so.8 => /usr/lib/x86_64-linux-gnu/libasn1.so.8 (0x00007f4f2e3d4000)</div><div> libhcrypto.so.4 => /usr/lib/x86_64-linux-gnu/libhcrypto.so.4 (0x00007f4f2e19f000)</div><div> libroken.so.18 => /usr/lib/x86_64-linux-gnu/libroken.so.18 (0x00007f4f2df8a000)</div>
<div> libtasn1.so.3 => /usr/lib/x86_64-linux-gnu/libtasn1.so.3 (0x00007f4f2dd79000)</div><div> libp11-kit.so.0 => /usr/lib/x86_64-linux-gnu/libp11-kit.so.0 (0x00007f4f2db66000)</div><div> libgpg-error.so.0 => /lib/x86_64-linux-gnu/libgpg-error.so.0 (0x00007f4f2d962000)</div>
<div> libwind.so.0 => /usr/lib/x86_64-linux-gnu/libwind.so.0 (0x00007f4f2d739000)</div><div> libheimbase.so.1 => /usr/lib/x86_64-linux-gnu/libheimbase.so.1 (0x00007f4f2d529000)</div><div> libhx509.so.5 => /usr/lib/x86_64-linux-gnu/libhx509.so.5 (0x00007f4f2d2df000)</div>
<div> libsqlite3.so.0 => /usr/lib/x86_64-linux-gnu/libsqlite3.so.0 (0x00007f4f2d03c000)</div></div><div><br></div><div><br></div><div>Any ideas on how I can fix this ?</div><div><br></div><div>Thanks</div></div>