[Pgpool-general] Problem when installing Pgpool-II

[Lazaro Rubén García Martinez]

Tatsuo, as you can say I am modified the Makefile of pgpool-regclass, I'm change the path of pg_config and after execute make, this error is shown:


make: pg_config: Command not found
make: pg_config: Command not found
make: pg_config: Command not found
make: pg_config: Command not found
make: pg_config: Command not found
make: pg_config: Command not found
make: pg_config: Command not found
make: pg_config: Command not found
make: pg_config: Command not found
make: pg_config: Command not found
gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing -fwrapv -fpic -I. -I. -I/server -I/internal -D_GNU_SOURCE   -c -o pgpool-regclass.o pgpool-regclass.c
pgpool-regclass.c:26:22: error: postgres.h: No such file or directory
pgpool-regclass.c:27:28: error: utils/builtins.h: No such file or directory
pgpool-regclass.c:28:28: error: utils/syscache.h: No such file or directory
pgpool-regclass.c:29:24: error: utils/elog.h: No such file or directory
pgpool-regclass.c:30:31: error: catalog/namespace.h: No such file or directory
pgpool-regclass.c:31:29: error: nodes/makefuncs.h: No such file or directory
pgpool-regclass.c:32:33: error: commands/dbcommands.h: No such file or directory
pgpool-regclass.c:33:18: error: fmgr.h: No such file or directory
pgpool-regclass.c:34:21: error: funcapi.h: No such file or directory
pgpool-regclass.c:42: warning: data definition has no type or storage class
pgpool-regclass.c:42: warning: type defaults to ‘int’ in declaration of ‘PG_FUNCTION_INFO_V1’
pgpool-regclass.c:42: warning: parameter names (without types) in function declaration
pgpool-regclass.c:44: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘pgpool_regclass’
pgpool-regclass.c:46: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘*’ token
pgpool-regclass.c:49: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘*’ token
pgpool-regclass.c:52: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘MyDatabaseId’
pgpool-regclass.c:56: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘get_namespace_oid’
pgpool-regclass.c:60: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘pgpool_regclass’
pgpool-regclass.c:108: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘*’ token
pgpool-regclass.c:143: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘*’ token
pgpool-regclass.c:189: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘get_namespace_oid’
make: *** [pgpool-regclass.o] Error 1


Is there a parameter or configuration file to say to pgpool-regclass and pgpool-recovery where Postgresql are installed??

Regards.

-----Mensaje original-----
De: Tatsuo Ishii [mailto:ishii at sraoss.co.jp] 
Enviado el: miércoles, 19 de octubre de 2011 11:01
Para: devrim at gunduz.org
CC: Lazaro Rubén García Martinez; pgpool-general at pgfoundry.org
Asunto: Re: [Pgpool-general] Problem when installing Pgpool-II

> On Wed, 2011-10-19 at 23:15 +0900, Tatsuo Ishii wrote:
>> You should put /opt/pgsql/bin in your command search path.
> 
> Why does --with-pgsql not picking up pg_config? It sounded a bit weird
> to me to add pg_config under $PATH. It's configure's job to pick it up.

Why? Even if configure picks up pg_config which is not in the command
search path, subsequent make of pgpool-regclass will fail because of
this anyway:

PGXS = $(shell pg_config --pgxs)

This is same as contrib Makefile of PostgreSQL(from PostgreSQL 9.0.5's
pgbench Makefile).

PG_CONFIG = pg_config
PGXS := $(shell $(PG_CONFIG) --pgxs)
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

> Regards, 
> -- 
> Devrim GÜNDÜZ
> Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
> PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
> Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
> http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz