[Pgpool-hackers] pgpool_adm for PostgreSQL 9.0

[Jehan-Guillaume (ioguix) de Rorthais]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 25/04/2011 16:08, Tatsuo Ishii wrote:
>> On 24/04/2011 12:31, Tatsuo Ishii wrote:
>>> Hi Jehan-Guillaume,
>>>
>>> [...]
>>> - Add SHLIB_LINK some parameters so that it referrers to
>>>   /usr/local/lib if libpcp is located in the directory. I know this is
>>>   horrible and it only works on Linux system but I don't know how to
>>>   enhance it.
>>
>> You don't need that. This should be set when configuring PostgreSQL
>> source tree. so:
>>
>>   * clean your postgresql source tree using "make distclean",
>>   * ./configure --whatever-options-you-need
>> - --with-libraries=/usr/local/lib --with-includes=/usr/local/include
>>   * (optional I guess) make && sudo make install
>>   * cd contrib/pgpool_adm && make && sudo make install
> 
> But this technique cannot be used with PostgreSQL rpm, no?

this technique allows to build pgpool_adm.so, then install it along
others contrib modules.

However, when calling pgpool_adm functions from psql, pgpool_adm.so will
look for libpcp.so.0 to try to load it.

In consequence, you need to set up your /etc/ld.so.conf (or add a file
in /etc/ld.so.conf.d/*.conf depending on your system) so it can find it:

  * add "/usr/local/lib" to your "/etc/ld.so.conf"
    (I added it in "/etc/ld.so.conf.d/local.conf")
  * run the following command as root:
    # ldconfig
  * check if libpcp is available:
    $ ldconfig -p | grep libpcp.so

Let me know if it work or not. Maybe I forgot smth, but it does compile
and work on my system without having to add this path in the Makefile...

>> In attachment, the new pgpool_adm with the new file "pgpol_adm.sql.in"
>> needed for PostgreSQL up to 9.0.
> 
> Thanks. Let me try.
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese: http://www.sraoss.co.jp
> 
>>> Hope this helps,
>>> --
>>> Tatsuo Ishii
>>> SRA OSS, Inc. Japan
>>> English: http://www.sraoss.co.jp/index_en.php
>>> Japanese: http://www.sraoss.co.jp
>> - -- 
>> Jehan-Guillaume (ioguix) de Rorthais
>> DBA
>> http://www.dalibo.com
>> -----BEGIN PGP SIGNATURE-----
>> Version: GnuPG v1.4.11 (GNU/Linux)
>> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/
>>
>> iEYEARECAAYFAk21X8sACgkQXu9L1HbaT6JmDgCfVH7P9BHbACLGMbj4GH/GiHCZ
>> 088AoOAbseyppKW7kvGoi7BL+JMikPyq
>> =c09y
>> -----END PGP SIGNATURE-----


- -- 
Jehan-Guillaume (ioguix) de Rorthais
DBA
http://www.dalibo.com
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAk21hA0ACgkQXu9L1HbaT6L7JQCgu13Shm6QwmTvapV/UvDDsSyl
M8AAn0UPk1+69Ucpfw69s8Ne5E4nGtOo
=IEFE
-----END PGP SIGNATURE-----