[Pgpool-hackers] pgpool_adm for PostgreSQL 9.0

[Tatsuo Ishii]

> On 24/04/2011 12:31, Tatsuo Ishii wrote:
>> Hi Jehan-Guillaume,
>> 
>> I have modified your pgpool_adm function so that it compiles under
>> PostgreSQL 9.0. I am not sure how I can make it compatible with
>> 9.1. So please consier this as my suggestion, not complete patches.
>> 
>> - Add pgpol_adm.sql.in so that make replaces 'MODULE_PATHNAME' to
>>   actual path name.
> 
> OK. But why the file "pgpool_adm--1.0.sql" in your tarball is using
> '$libdir/pgpool_adm--1.0' instead of 'MODULE_PATHNAME' ?

Probably I just tried to use $libdir...

> Actually, "pgpool_adm--1.0.sql" and "pgpol_adm.sql.in" seems to be
> strictly the same, but "pgpool_adm--1.0.sql" is for 9.1+ and
> "pgpol_adm.sql.in" up to 9.0.
> 
>> - 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?

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