[Pgpool-hackers] pgpool_adm for PostgreSQL 9.0

[Tatsuo Ishii]

>>>> - 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...

I know using ldconfig will do the trick but this requires root
privilege, which is not always available for DB admin. Also some
people don't want to add /usr/local/lib to ld.so.conf for a security
reason.

So customizing Makefile is better, I think.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

>>> 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-----