[Pgpool-general] Pgpool-general Digest, Vol 72, Issue 22

Wed Nov 24 21:00:08 UTC 2010

pgpool-general-request at pgfoundry.org escribió:
> Send Pgpool-general mailing list submissions to
> 	pgpool-general at pgfoundry.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
> 	http://pgfoundry.org/mailman/listinfo/pgpool-general
> or, via email, send a message with subject or body 'help' to
> 	pgpool-general-request at pgfoundry.org
>
> You can reach the person managing the list at
> 	pgpool-general-owner at pgfoundry.org
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of Pgpool-general digest..."
>
>
> Today's Topics:
>
>    1. Problem running the command ./configure
>       (Felix Noel Abelardo Santana)
>    2. Re: Problem running the command ./configure (Devrim G?ND?Z)
>    3. Why if standby goes down the INSERT query fails?
>       (Alessandro Candini)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Tue, 23 Nov 2010 16:29:26 -0500
> From: Felix Noel Abelardo Santana <fnabelardo at uci.cu>
> Subject: [Pgpool-general] Problem running the command ./configure
> To: pgpool-general at pgfoundry.org
> Message-ID: <4CEC3236.4090706 at uci.cu>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> Hi I am following step by step tutorial is at:
> http://pgpool.projects.postgresql.org/contrib_docs/simple_sr_setting/
>
> I have a PC in Ubuntu 10.4 in Spanish, finished formatting and only have 
> installed the Postgresql 9.0.1, installed it visually, and was installed 
> in the /opt/PostgreSQL.
> I follow the tutorial steps to the part that says ./configure and I get 
> the following error:
>
> ------------------------------------------------------------
> postgres at server03:~/pgpool-II-3.1.0-alpha1$ ./configure
> 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... i686-pc-linux-gnu
> checking host system type... i686-pc-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... 1572864
> 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) 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... no
> checking whether long long int is 64 bits... yes
> checking snprintf format for long long int... %lld
> checking size of unsigned long... 4
> checking size of void *... 4
> checking size of size_t... 4
> checking whether to build with float4 passed by value... yes
> checking whether to build with float8 passed by value... no
> 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
> -------------------------------------------------------------------
>
> Do I have to install something else before installing the PGPool? 
> Whatever you have to install would be helpful because I am new to this 
> and I have no experience.
>
> How do I recognize pg_config?
>
> How do I fix the error "configure: error: libpq is not installed or 
> libpq is old?
>
> Greetings Felix Noel .
>
>
>
> ------------------------------
>
> Message: 2
> Date: Wed, 24 Nov 2010 00:38:00 +0200
> From: Devrim G?ND?Z <devrim at gunduz.org>
> Subject: Re: [Pgpool-general] Problem running the command ./configure
> To: Felix Noel Abelardo Santana <fnabelardo at uci.cu>
> Cc: pgpool-general at pgfoundry.org
> Message-ID: <1290551880.2572.0.camel at hp-laptop02.gunduz.org>
> Content-Type: text/plain; charset="utf-8"
>
> On Tue, 2010-11-23 at 16:29 -0500, Felix Noel Abelardo Santana wrote:
>   
>> checking for pg_config... no
>> checking for PQexecPrepared in -lpq... no
>> configure: error: libpq is not installed or libpq is old
>> ------------------------------------------------------------ 
>>     
>
> You need to pass --with-pgsql=/opt/PostgreSQL to configure script, so
> that it can find pg_config.
>   
Ran ./configure --with-pgsql=/opt/PostgreSQL/9.0/
and the error continues. That is the root directory of the install of 
Postgres, why not give that error.
What else I can do about it?

Error:
postgres at server03:~/pgpool-II-3.1.0-alpha1$ ./configure 
--with-pgsql=/opt/PostgreSQL/9.0/
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... i686-pc-linux-gnu
checking host system type... i686-pc-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... 1572864
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) 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... no
checking whether long long int is 64 bits... yes
checking snprintf format for long long int... %lld
checking size of unsigned long... 4
checking size of void *... 4
checking size of size_t... 4
checking whether to build with float4 passed by value... yes
checking whether to build with float8 passed by value... no
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