[Pgpool-hackers] pgpool_adm for PostgreSQL 9.0

[Jehan-Guillaume (ioguix) de Rorthais]

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

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

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


In attachment, the new pgpool_adm with the new file "pgpol_adm.sql.in"
needed for PostgreSQL up to 9.0.

> 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-----
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pgpool_adm-5.tar.gz
Type: application/gzip
Size: 3517 bytes
Desc: not available
URL: <http://pgfoundry.org/pipermail/pgpool-hackers/attachments/20110425/2fee1258/attachment.bin>