Re: Como configurar PGpool solo para un pool de conexiones...

Mira esta respuesta

"hola marcos:

si efectivamente me dio ese error, lo estas compilando a 64 bits??
porque a mi ese error me lo marco en un server de 64 bits.

lo que hice fue modificar los archivos pool.c y recovery.h o algo asi
son esos dos archivos, por ahi solo le indique en el *include* la ruta
completa del libpq, son esos 2 archivos, no me acuerdo muy
bien de las extenciones pero si con POOL y RECOVERY
basta de modificar para que se pueda instalar!!

O eso te puede marcar por que no tienes instalado las librerias para
compilar o no tienes postgres instalado!! por el momento es de lo que
me acuerdo. Pero creo con eso basta!!

y efectivamente no hay RPM a pura compliacion de codigo

y no me hables de usted dime Miguel!! me haces sentir algo viejo
jejejejejejeje

espero y esta informacion te pueda ayudar y que tengas un excelente dia y
un bonito comienzo de semana!!

Yo trabajo en Opensuse 11.1. En el lugar que me indicaste no hay pgpol-II
en rpm para ese sistema me imagino que usted tuvo que compilar.

Al compilarlo me dio este error, a usted le dio algo parecido.

checking for gcc... gcc
checking for C compiler default output file name... a.out
checking whether the C compiler works... yes
checking whether we are cross compiling... no
checking for suffix of executables...
checking for suffix of object files... o
checking whether we are using the GNU C compiler... yes
checking whether gcc accepts -g... yes
checking for gcc option to accept ANSI C... none needed
checking for a BSD-compatible install... /usr/bin/install -c
checking whether build environment is sane... yes
checking for gawk... gawk
checking whether make sets $(MAKE)... yes
checking for style of include used by make... GNU
checking dependency style of gcc... gcc3
checking for ranlib... ranlib
checking build system type... i686-pc-linux-gnu
checking host system type... i686-pc-linux-gnu
checking for a sed that does not truncate output... /usr/bin/sed
checking for egrep... grep -E
checking for ld used by gcc... /usr/i586-suse-linux/bin/ld
checking if the linker (/usr/i586-suse-linux/bin/ld) is GNU ld... yes
checking for /usr/i586-suse-linux/bin/ld option to reload object files... -r
checking for BSD-compatible nm... /usr/bin/nm -B
checking whether ln -s works... yes
checking how to recognise dependent libraries... pass_all
checking how to run the C preprocessor... gcc -E
checking for ANSI C header files... yes
checking for sys/types.h... yes
checking for sys/stat.h... yes
checking for stdlib.h... yes
checking for string.h... yes
checking for memory.h... yes
checking for strings.h... yes
checking for inttypes.h... yes
checking for stdint.h... yes
checking for unistd.h... yes
checking dlfcn.h usability... yes
checking dlfcn.h presence... yes
checking for dlfcn.h... yes
checking for g++... no
checking for c++... no
checking for gpp... no
checking for aCC... no
checking for CC... no
checking for cxx... no
checking for cc++... no
checking for cl... no
checking for FCC... no
checking for KCC... no
checking for RCC... no
checking for xlC_r... no
checking for xlC... no
checking whether we are using the GNU C++ compiler... no
checking whether g++ accepts -g... no
checking dependency style of g++... none
checking for g77... no
checking for f77... no
checking for xlf... no
checking for frt... no
checking for pgf77... no
checking for fort77... no
checking for fl32... no
checking for af77... no
checking for f90... no
checking for xlf90... no
checking for pgf90... no
checking for epcf90... no
checking for f95... no
checking for fort... no
checking for xlf95... no
checking for ifc... no
checking for efc... no
checking for pgf95... no
checking for lf95... no
checking for gfortran... no
checking whether we are using the GNU Fortran 77 compiler... no
checking whether accepts -g... no
checking the maximum length of command line arguments... 32768
checking command to parse /usr/bin/nm -B output from gcc object... ok
checking for objdir... .libs
checking for ar... ar
checking for ranlib... (cached) ranlib
checking for strip... strip
checking if gcc supports -fno-rtti -fno-exceptions... no
checking for gcc option to produce PIC... -fPIC
checking if gcc PIC flag -fPIC works... yes
checking if gcc static flag -static works... yes
checking if gcc supports -c -o file.o... yes
checking whether the gcc linker (/usr/i586-suse-linux/bin/ld) supports
shared libraries... yes
checking whether -lc should be explicitly linked in... no
checking dynamic linker characteristics... GNU/Linux ld.so
checking how to hardcode library paths into programs... immediate
checking whether stripping libraries is possible... yes
checking if libtool supports shared libraries... yes
checking whether to build shared libraries... yes
checking whether to build static libraries... yes
configure: creating libtool
appending configuration tag "CXX" to libtool
appending configuration tag "F77" to libtool
checking for flex... no
checking for lex... no
checking for yywrap in -lfl... no
checking for yywrap in -ll... no
checking for bison... no
checking for byacc... no
checking for -Wall option... yes
checking for -Wmissing-prototypes option... yes
checking for -Wmissing-declarations option... yes
checking for main in -lm... yes
checking for main in -lnsl... yes
checking for main in -lsocket... no
checking for main in -lipc... no
checking for main in -lIPC... no
checking for main in -llc... no
checking for main in -lcompat... no
checking for main in -lBSD... no
checking for main in -lgen... no
checking for main in -lPW... no
checking for main in -lresolv... yes
checking for ANSI C header files... (cached) yes
checking for sys/wait.h that is POSIX.1 compatible... yes
checking fcntl.h usability... yes
checking fcntl.h presence... yes
checking for fcntl.h... yes
checking for unistd.h... (cached) yes
checking getopt.h usability... yes
checking getopt.h presence... yes
checking for getopt.h... yes
checking netinet/tcp.h usability... yes
checking netinet/tcp.h presence... yes
checking for netinet/tcp.h... yes
checking netinet/in.h usability... yes
checking netinet/in.h presence... yes
checking for netinet/in.h... yes
checking netdb.h usability... yes
checking netdb.h presence... yes
checking for netdb.h... yes
checking sys/param.h usability... yes
checking sys/param.h presence... yes
checking for sys/param.h... yes
checking for sys/types.h... (cached) yes
checking sys/socket.h usability... yes
checking sys/socket.h presence... yes
checking for sys/socket.h... yes
checking sys/un.h usability... yes
checking sys/un.h presence... yes
checking for sys/un.h... yes
checking sys/time.h usability... yes
checking sys/time.h presence... yes
checking for sys/time.h... yes
checking sys/sem.h usability... yes
checking sys/sem.h presence... yes
checking for sys/sem.h... yes
checking sys/shm.h usability... yes
checking sys/shm.h presence... yes
checking for sys/shm.h... yes
checking sys/select.h usability... yes
checking sys/select.h presence... yes
checking for sys/select.h... yes
checking crypt.h usability... yes
checking crypt.h presence... yes
checking for crypt.h... yes
checking sys/pstat.h usability... no
checking sys/pstat.h presence... no
checking for sys/pstat.h... no
checking for an ANSI C-conforming const... yes
checking for pid_t... yes
checking whether time.h and sys/time.h may both be included... yes
checking for struct sockaddr_storage... yes
checking for struct sockaddr_storage.ss_family... yes
checking for struct sockaddr_storage.__ss_family... no
checking for struct sockaddr_storage.ss_len... no
checking for struct sockaddr_storage.__ss_len... no
checking for struct sockaddr.sa_len... no
checking for union semun... no
checking return type of signal handlers... void
checking for vprintf... yes
checking for _doprnt... no
checking for wait3 that fills in rusage... yes
checking types of arguments for accept()... int, int, struct sockaddr *,
size_t *
checking for setsid... yes
checking for select... yes
checking for socket... yes
checking for sigprocmask... yes
checking for strdup... yes
checking for strerror... yes
checking for strftime... yes
checking for strtok... yes
checking for asprintf... yes
checking for gai_strerror... yes
checking for hstrerror... yes
checking for pstat... no
checking for setproctitle... no
checking for pg_config... no
checking for PQexecPrepared in -lpq... no
configure: error: libpq is not installed or libpq is old
Servidor:/usr/local/src/pgpool-II-2.2.2 #

----- Mensaje original -----
De: Miguel Angel Hernandez Moreno <miguel(dot)hdz(dot)mrn(at)gmail(dot)com>
Fecha: Viernes, 28 de Mayo de 2010, 4:55 pm
Asunto: Re: pgpool
A: MARCOS ALEXIS VENEGAS ALVAREZ <marcoselche(at)costarricense(dot)cr>
- Ocultar texto citado -

> lo descargue de pgfoundry
>
>
> http://pgfoundry.org/frs/?group_id=1000055&release_id=1634<http://pgfoundry.org/frs/?group_id=1000055&release_id=1634>
>
> por ahi viene pgpool-II yo uso la version 2.3.2.2
>
> espero y e pueda ayudar esta informacion
>
>
> El 28 de mayo de 2010 15:58, MARCOS ALEXIS VENEGAS ALVAREZ <
marcoselche(at)costarricense(dot)cr> escribió:

> > Buenas tardes, he mirado en la lista de postgresql que buscabas una
> libreria para instalar pgpool en opensuse 11.2, yo necesito instalar
> pgpool en ese sitema operativo y quisiera saber donde conseguiste el
> pgpool que usaste. Muchas gracias.

"
2011/10/4 Marcos Luis Ortiz Valmaseda <marcosluis2186(at)googlemail(dot)com>

> Primero te recomiendo que agregues a tu sistema estos repositorios
> http://yum.pgrpms.org/howtoyum.php
> Luego actualizas la libreria que te dice, en este caso libpq,la cual es una
> dependencia de PgPool.
>
> Saludos
>
>
> 2011/10/4 Matias Israel Malpica Escobar <Matias(dot)Malpica(at)thyssenkrupp(dot)com>
>
>> Saludos, estoy atorado con la instalacion del pgpool, he buscad por la
>> red y no encuentro una solucion, ya busque la libreria libpq y existe en el
>> directorio lib64 (a donde lo estoy direccionando) alguna sugerencia??
>>
>> [root(at)10-166-36-16 pgpool-II-3.1]# ./configure --prefix=/usr/bin/pgpoolII
>> --with-pgsql-libdir=/usr/bin/lib64/ --with-pgsql-includedir=/var/lib/pgsql/
>> make makeinstall
>> configure: WARNING: you should use --build, --host, --target
>> configure: WARNING: you should use --build, --host, --target
>> checking for make-gcc... no
>> checking for gcc... gcc
>> checking for C compiler default output file name... a.out
>> checking whether the C compiler works... yes
>> checking whether we are cross compiling... no
>> checking for suffix of executables...
>> checking for suffix of object files... o
>> checking whether we are using the GNU C compiler... yes
>> checking whether gcc accepts -g... yes
>> checking for gcc option to accept ISO C89... none needed
>> checking for a BSD-compatible install... /usr/bin/install -c
>> checking whether build environment is sane... yes
>> checking for a thread-safe mkdir -p... /bin/mkdir -p
>> checking for gawk... gawk
>> checking whether make sets $(MAKE)... yes
>> checking for style of include used by make... GNU
>> checking dependency style of gcc... gcc3
>> checking for make-ranlib... no
>> checking for ranlib... ranlib
>> checking build system type... Invalid configuration `make': machine `make'
>> not recognized
>> configure: error: /bin/sh ./config.sub make failed
>> [root(at)10-166-36-16 pgpool-II-3.1]# yum install make
>> Loaded plugins: fastestmirror
>> Loading mirror speeds from cached hostfile
>> * base: mirror.cogentco.com
>> * extras: mirror.vcu.edu
>> * rpmforge: apt.sw.be
>> * updates: mirror.net.cen.ct.gov
>> Setting up Install Process
>> Package 1:make-3.81-3.el5.x86_64 already installed and latest version
>> Nothing to do
>> [root(at)10-166-36-16 pgpool-II-3.1]# ./configure --prefix=/usr/bin/pgpoolII
>> --with-pgsql-libdir=/usr/bin/lib64/ --with-pgsql-includedir=/var/lib/pgsql/
>> makeinstall
>> configure: WARNING: you should use --build, --host, --target
>> checking for makeinstall-gcc... no
>> checking for gcc... gcc
>> checking for C compiler default output file name... a.out
>> checking whether the C compiler works... yes
>> checking whether we are cross compiling... no
>> checking for suffix of executables...
>> checking for suffix of object files... o
>> checking whether we are using the GNU C compiler... yes
>> checking whether gcc accepts -g... yes
>> checking for gcc option to accept ISO C89... none needed
>> checking for a BSD-compatible install... /usr/bin/install -c
>> checking whether build environment is sane... yes
>> checking for a thread-safe mkdir -p... /bin/mkdir -p
>> checking for gawk... gawk
>> checking whether make sets $(MAKE)... yes
>> checking for style of include used by make... GNU
>> checking dependency style of gcc... gcc3
>> checking for makeinstall-ranlib... no
>> checking for ranlib... ranlib
>> checking build system type... Invalid configuration `makeinstall': machine
>> `makeinstall' not recognized
>> configure: error: /bin/sh ./config.sub makeinstall failed
>> [root(at)10-166-36-16 pgpool-II-3.1]# ./configure --prefix=/usr/bin/pgpoolII
>> --with-pgsql-libdir=/usr/bin/lib64/ --with-pgsql-includedir=/var/lib/pgsql/
>> checking for gcc... gcc
>> checking for C compiler default output file name... a.out
>> checking whether the C compiler works... yes
>> checking whether we are cross compiling... no
>> checking for suffix of executables...
>> checking for suffix of object files... o
>> checking whether we are using the GNU C compiler... yes
>> checking whether gcc accepts -g... yes
>> checking for gcc option to accept ISO C89... none needed
>> checking for a BSD-compatible install... /usr/bin/install -c
>> checking whether build environment is sane... yes
>> checking for a thread-safe mkdir -p... /bin/mkdir -p
>> checking for gawk... gawk
>> checking whether make sets $(MAKE)... yes
>> checking for style of include used by make... GNU
>> checking dependency style of gcc... gcc3
>> checking for ranlib... ranlib
>> checking build system type... x86_64-unknown-linux-gnu
>> checking host system type... x86_64-unknown-linux-gnu
>> checking for a sed that does not truncate output... /bin/sed
>> checking for grep that handles long lines and -e... /bin/grep
>> checking for egrep... /bin/grep -E
>> checking for fgrep... /bin/grep -F
>> checking for ld used by gcc... /usr/bin/ld
>> checking if the linker (/usr/bin/ld) is GNU ld... yes
>> checking for BSD- or MS-compatible name lister (nm)... /usr/bin/nm -B
>> checking the name lister (/usr/bin/nm -B) interface... BSD nm
>> checking whether ln -s works... yes
>> checking the maximum length of command line arguments... 98304
>> checking whether the shell understands some XSI constructs... yes
>> checking whether the shell understands "+="... yes
>> checking for /usr/bin/ld option to reload object files... -r
>> checking for objdump... objdump
>> checking how to recognize dependent libraries... pass_all
>> checking for ar... ar
>> checking for strip... strip
>> checking for ranlib... (cached) ranlib
>> checking command to parse /usr/bin/nm -B output from gcc object... ok
>> checking how to run the C preprocessor... gcc -E
>> checking for ANSI C header files... yes
>> checking for sys/types.h... yes
>> checking for sys/stat.h... yes
>> checking for stdlib.h... yes
>> checking for string.h... yes
>> checking for memory.h... yes
>> checking for strings.h... yes
>> checking for inttypes.h... yes
>> checking for stdint.h... yes
>> checking for unistd.h... yes
>> checking for dlfcn.h... yes
>> checking for objdir... .libs
>> checking if gcc supports -fno-rtti -fno-exceptions... no
>> checking for gcc option to produce PIC... -fPIC -DPIC
>> checking if gcc PIC flag -fPIC -DPIC works... yes
>> checking if gcc static flag -static works... yes
>> checking if gcc supports -c -o file.o... yes
>> checking if gcc supports -c -o file.o... (cached) yes
>> checking whether the gcc linker (/usr/bin/ld -m elf_x86_64) supports
>> shared libraries... yes
>> checking whether -lc should be explicitly linked in... no
>> checking dynamic linker characteristics... GNU/Linux ld.so
>> checking how to hardcode library paths into programs... immediate
>> checking whether stripping libraries is possible... yes
>> checking if libtool supports shared libraries... yes
>> checking whether to build shared libraries... yes
>> checking whether to build static libraries... yes
>> checking for flex... no
>> checking for lex... no
>> checking for bison... no
>> checking for byacc... no
>> checking for -Wall option... yes
>> checking for -Wmissing-prototypes option... yes
>> checking for -Wmissing-declarations option... yes
>> checking for main in -lm... yes
>> checking for main in -lnsl... yes
>> checking for main in -lsocket... no
>> checking for main in -lipc... no
>> checking for main in -lIPC... no
>> checking for main in -llc... no
>> checking for main in -lcompat... no
>> checking for main in -lBSD... no
>> checking for main in -lgen... no
>> checking for main in -lPW... no
>> checking for main in -lresolv... yes
>> checking for main in -lcrypt... yes
>> checking for ANSI C header files... (cached) yes
>> checking for sys/wait.h that is POSIX.1 compatible... yes
>> checking fcntl.h usability... yes
>> checking fcntl.h presence... yes
>> checking for fcntl.h... yes
>> checking for unistd.h... (cached) yes
>> checking getopt.h usability... yes
>> checking getopt.h presence... yes
>> checking for getopt.h... yes
>> checking netinet/tcp.h usability... yes
>> checking netinet/tcp.h presence... yes
>> checking for netinet/tcp.h... yes
>> checking netinet/in.h usability... yes
>> checking netinet/in.h presence... yes
>> checking for netinet/in.h... yes
>> checking netdb.h usability... yes
>> checking netdb.h presence... yes
>> checking for netdb.h... yes
>> checking sys/param.h usability... yes
>> checking sys/param.h presence... yes
>> checking for sys/param.h... yes
>> checking for sys/types.h... (cached) yes
>> checking sys/socket.h usability... yes
>> checking sys/socket.h presence... yes
>> checking for sys/socket.h... yes
>> checking sys/un.h usability... yes
>> checking sys/un.h presence... yes
>> checking for sys/un.h... yes
>> checking sys/time.h usability... yes
>> checking sys/time.h presence... yes
>> checking for sys/time.h... yes
>> checking sys/sem.h usability... yes
>> checking sys/sem.h presence... yes
>> checking for sys/sem.h... yes
>> checking sys/shm.h usability... yes
>> checking sys/shm.h presence... yes
>> checking for sys/shm.h... yes
>> checking sys/select.h usability... yes
>> checking sys/select.h presence... yes
>> checking for sys/select.h... yes
>> checking crypt.h usability... yes
>> checking crypt.h presence... yes
>> checking for crypt.h... yes
>> checking sys/pstat.h usability... no
>> checking sys/pstat.h presence... no
>> checking for sys/pstat.h... no
>> checking for an ANSI C-conforming const... yes
>> checking for pid_t... yes
>> checking whether time.h and sys/time.h may both be included... yes
>> checking whether long int is 64 bits... yes
>> checking size of unsigned long... 8
>> checking size of void *... 8
>> checking size of size_t... 8
>> checking whether to build with float4 passed by value... yes
>> checking whether to build with float8 passed by value... yes
>> checking for struct sockaddr_storage... yes
>> checking for struct sockaddr_storage.ss_family... yes
>> checking for struct sockaddr_storage.__ss_family... no
>> checking for struct sockaddr_storage.ss_len... no
>> checking for struct sockaddr_storage.__ss_len... no
>> checking for struct sockaddr.sa_len... no
>> checking for union semun... no
>> checking return type of signal handlers... void
>> checking for vprintf... yes
>> checking for _doprnt... no
>> checking for wait3 that fills in rusage... yes
>> checking types of arguments for accept()... int, int, struct sockaddr *,
>> socklen_t *
>> checking for setsid... yes
>> checking for select... yes
>> checking for socket... yes
>> checking for sigprocmask... yes
>> checking for strdup... yes
>> checking for strerror... yes
>> checking for strftime... yes
>> checking for strtok... yes
>> checking for asprintf... yes
>> checking for gai_strerror... yes
>> checking for hstrerror... yes
>> checking for pstat... no
>> checking for setproctitle... no
>> checking for pg_config... no
>> checking for PQexecPrepared in -lpq... no
>> configure: error: libpq is not installed or libpq is old
>>
>> ------------------------------
>> *De:* Miguel Angel Hernandez Moreno [miguel(dot)hdz(dot)mrn(at)gmail(dot)com]
>> *Enviado el:* martes, 04 de octubre de 2011 10:33 a.m.
>> *Para:* Matias Israel Malpica Escobar
>> *CC:* pgsql-es-ayuda(at)postgresql(dot)org
>> *Asunto:* Re: [pgsql-es-ayuda] Como configurar PGpool solo para un pool
>> de conexiones...
>>
>> Yo te recomiendo
>>
>> http://www.postgresql.org.es/node/313
>>
>> En la primera parte viene lo del pooling, pero es algo muy completo
>>
>> El 4 de octubre de 2011 09:29, Matias Israel Malpica Escobar <
>> Matias(dot)Malpica(at)thyssenkrupp(dot)com> escribió:
>>
>>> Hola estoy en el proceso de configurar pgpool, por el momento solo me
>>> interesa hacer pruebas con el pool de conexiones, y no tanto con balanceo,
>>> creacion de nodos etc... He intentado buscar la configuracion para el pool
>>> pero no he encontrado mucho, alguien me puede ayudar?
>>>
>>> Saludos!
>>>
>>
>>
>>
>> --
>> ISC Miguel Angel Hernandez Moreno
>>
>>
>
>
> --
> Marcos Luis Ortíz Valmaseda
> Linux Infrastructure Engineer
> Linux User # 418229
> http://marcosluis2186.posterous.com
> http://www.linkedin.com/in/marcosluis2186
> Twitter: @marcosluis2186
>
>

--
ISC Miguel Angel Hernandez Moreno