ABOUT ME

-

Today
-
Yesterday
-
Total
-
  • pgPool-II 설치
    PostgreSQL 2019. 10. 11. 13:56

    pgPool-II 설치에 대해 설명한다.

    설치

    시나리오

    1. 의존 라이브러리 설치
    2. 소스코드 다운로드
    3. configure
    4. make install 
    5. pgpool-recover
    6. postgresql.conf 설정
    7. pgpool.conf 생성
    8. pgpool 시작
    9. pgpool 접속 
    10. 10 클라이언트 테스트
    11. 80 클라이언트 테스트
    12. pgpool 종료

    다음은 위 시나리오를 실행한 명령어이다.

    1. 의존 라이브러리 설치
    GNU GCC 3.8 이상
     
    2. 소스코드 다운로드
    $ wget https://github.com/pgpool/pgpool2/archive/V4_0_1.tar.gz
    [bylee@bylee5 install]$ tar xf V4_0_1.tar.gz
    [bylee@bylee5 install]$ cd pgpool2-4_0_1
    [bylee@bylee5 pgpool2-4_0_1]$ ll
    합계 1516
    -rw-rw-r--.  1 bylee bylee    123 10월 31 11:11 AUTHORS
    -rw-rw-r--.  1 bylee bylee    666 10월 31 11:11 COPYING
    -rw-rw-r--.  1 bylee bylee     10 10월 31 11:11 ChangeLog
    -rw-rw-r--.  1 bylee bylee  15744 10월 31 11:11 INSTALL
    -rw-rw-r--.  1 bylee bylee    249 10월 31 11:11 Makefile.am
    -rw-rw-r--.  1 bylee bylee  25281 10월 31 11:11 Makefile.in
    -rw-rw-r--.  1 bylee bylee 441205 10월 31 11:11 NEWS
    -rw-rw-r--.  1 bylee bylee     32 10월 31 11:11 README
    -rw-rw-r--.  1 bylee bylee   1261 10월 31 11:11 README.build
    -rw-rw-r--.  1 bylee bylee     36 10월 31 11:11 README.euc_jp
    -rw-rw-r--.  1 bylee bylee   2156 10월 31 11:11 README.online-recovery
    -rw-rw-r--.  1 bylee bylee   2381 10월 31 11:11 TODO
    -rw-rw-r--.  1 bylee bylee   3641 10월 31 11:11 ac_func_accept_argtypes.m4
    -rw-rw-r--.  1 bylee bylee  30871 10월 31 11:11 aclocal.m4
    -rw-rw-r--.  1 bylee bylee   4351 10월 31 11:11 c-compiler.m4
    -rw-rw-r--.  1 bylee bylee  10772 10월 31 11:11 c-library.m4
    -rw-rw-r--.  1 bylee bylee      0 10월 31 11:11 compile
    -rwxrwxr-x.  1 bylee bylee  44826 10월 31 11:11 config.guess
    -rwxrwxr-x.  1 bylee bylee  35454 10월 31 11:11 config.sub
    -rwxrwxr-x.  1 bylee bylee 497862 10월 31 11:11 configure
    -rw-rw-r--.  1 bylee bylee  15465 10월 31 11:11 configure.ac
    -rwxrwxr-x.  1 bylee bylee  20334 10월 31 11:11 depcomp
    drwxrwxr-x.  3 bylee bylee   4096 10월 31 11:11 doc
    drwxrwxr-x.  3 bylee bylee   4096 10월 31 11:11 doc.ja
    -rw-rw-r--.  1 bylee bylee   5960 10월 31 11:11 general.m4
    -rwxrwxr-x.  1 bylee bylee  13998 10월 31 11:11 install-sh
    -rwxrwxr-x.  1 bylee bylee 283680 10월 31 11:11 ltmain.sh
    drwxrwxr-x.  2 bylee bylee   4096 10월 31 11:11 m4
    -rwxrwxr-x.  1 bylee bylee  10346 10월 31 11:11 missing
    -rwxrwxr-x.  1 bylee bylee   3538 10월 31 11:11 mkinstalldirs
    drwxrwxr-x. 21 bylee bylee   4096 10월 31 11:11 src
    -rwxrwxr-x.  1 bylee bylee   6383 10월 31 11:11 ylwrap
     
    3. configure
    [bylee@bylee5 pgpool2-4_0_1]$ ./configure --prefix=$(pwd) --with-pgsql=/home/bylee/install/agensgraph
    checking for gcc... gcc
    checking whether the C compiler works... yes
    checking for C compiler default output file name... a.out
    checking for suffix of executables...
    checking whether we are cross compiling... no
    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
    /home/bylee/install/pgpool2-4_0_1/missing: Unknown `--is-lightweight' option
    Try `/home/bylee/install/pgpool2-4_0_1/missing --help' for more information
    configure: WARNING: 'missing' script is too old or missing
    checking for a thread-safe mkdir -p... /usr/bin/mkdir -p
    checking for gawk... gawk
    checking whether make sets $(MAKE)... yes
    checking whether make supports nested variables... yes
    checking whether to enable maintainer-specific portions of Makefiles... no
    checking build system type... x86_64-unknown-linux-gnu
    checking host system type... x86_64-unknown-linux-gnu
    checking how to print strings... printf
    checking for a sed that does not truncate output... /usr/bin/sed
    checking for grep that handles long lines and -e... /usr/bin/grep
    checking for egrep... /usr/bin/grep -E
    checking for fgrep... /usr/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 how to convert x86_64-unknown-linux-gnu file names to x86_64-unknown-linux-gnu format... func_convert_file_noop
    checking how to convert x86_64-unknown-linux-gnu file names to toolchain format... func_convert_file_noop
    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 dlltool... no
    checking how to associate runtime and link libraries... printf %s\n
    checking for ar... ar
    checking for archiver @FILE support... @
    checking for strip... strip
    checking for ranlib... ranlib
    checking command to parse /usr/bin/nm -B output from gcc object... ok
    checking for sysroot... no
    checking for mt... no
    checking if : is a manifest tool... no
    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... no
    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... flex
    checking lex output file root... lex.yy
    checking lex library... none needed
    checking whether yytext is a pointer... no
    checking for bison... bison -y
    checking whether gcc and cc understand -c and -o together... yes
    checking for onsgmls... no
    checking for nsgmls... no
    checking for openjade... no
    checking for jade... no
    checking for DocBook V4.2... no
    checking for DocBook stylesheets... no
    checking for collateindex.pl... no
    checking for xsltproc... xsltproc
    checking for xmllint... xmllint
    checking for osx... no
    checking for sgml2xml... no
    checking for sx... sx
    checking for perl... perl
    checking for lynx... 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 -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 strlcat,... no
    checking for strlcpy... no
    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 termios.h usability... yes
    checking termios.h presence... yes
    checking for termios.h... yes
    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 snprintf... yes
    checking for vsnprintf... 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 vasprintf... yes
    checking for gai_strerror... yes
    checking for hstrerror... yes
    checking for pstat... no
    checking for setproctitle... no
    checking for vsyslog... yes
    checking for pg_config... pg_config
    checking for PQexecPrepared in -lpq... yes
    checking for PQprepare... yes
    checking whether to use row lock against the sequence table for insert_lock... no
    checking whether to use table lock against the target table for insert_lock... no
    enable cassert = no
    checking that generated files are newer than configure... done
    configure: creating ./config.status
    config.status: creating Makefile
    config.status: creating doc/Makefile
    config.status: creating doc/src/Makefile
    config.status: creating doc/src/sgml/Makefile
    config.status: creating doc.ja/Makefile
    config.status: creating doc.ja/src/Makefile
    config.status: creating doc.ja/src/sgml/Makefile
    config.status: creating src/Makefile
    config.status: creating src/include/Makefile
    config.status: creating src/parser/Makefile
    config.status: creating src/libs/Makefile
    config.status: creating src/libs/pcp/Makefile
    config.status: creating src/tools/Makefile
    config.status: creating src/tools/pgmd5/Makefile
    config.status: creating src/tools/pgenc/Makefile
    config.status: creating src/tools/pcp/Makefile
    config.status: creating src/tools/pgproto/Makefile
    config.status: creating src/watchdog/Makefile
    config.status: creating src/include/config.h
    config.status: executing libtool commands
    [bylee@bylee5 pgpool2-4_0_1]$
     
    4. make install
    [bylee@bylee5 pgpool2-4_0_1]$ make install
    Making install in src
    make[1]: 디렉터리 '/home/bylee/install/pgpool2-4_0_1/src' 들어감
    Making install in parser
    make[2]: 디렉터리 '/home/bylee/install/pgpool2-4_0_1/src/parser' 들어감
    gcc -DHAVE_CONFIG_H -I. -I../../src/include  -D_GNU_SOURCE -I ../../src/include/parser -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o copyfuncs.o copyfuncs.c
    gcc -DHAVE_CONFIG_H -I. -I../../src/include  -D_GNU_SOURCE -I ../../src/include/parser -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o gram.o gram.c
    gcc -DHAVE_CONFIG_H -I. -I../../src/include  -D_GNU_SOURCE -I ../../src/include/parser -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o keywords.o keywords.c
    gcc -DHAVE_CONFIG_H -I. -I../../src/include  -D_GNU_SOURCE -I ../../src/include/parser -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o list.o list.c
    gcc -DHAVE_CONFIG_H -I. -I../../src/include  -D_GNU_SOURCE -I ../../src/include/parser -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o makefuncs.o makefuncs.c
    gcc -DHAVE_CONFIG_H -I. -I../../src/include  -D_GNU_SOURCE -I ../../src/include/parser -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o nodes.o nodes.c
    gcc -DHAVE_CONFIG_H -I. -I../../src/include  -D_GNU_SOURCE -I ../../src/include/parser -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o outfuncs.o outfuncs.c
    gcc -DHAVE_CONFIG_H -I. -I../../src/include  -D_GNU_SOURCE -I ../../src/include/parser -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o parser.o parser.c
    gcc -DHAVE_CONFIG_H -I. -I../../src/include  -D_GNU_SOURCE -I ../../src/include/parser -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o pool_string.o pool_string.c
    gcc -DHAVE_CONFIG_H -I. -I../../src/include  -D_GNU_SOURCE -I ../../src/include/parser -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o scansup.o scansup.c
    gcc -DHAVE_CONFIG_H -I. -I../../src/include  -D_GNU_SOURCE -I ../../src/include/parser -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o stringinfo.o stringinfo.c
    gcc -DHAVE_CONFIG_H -I. -I../../src/include  -D_GNU_SOURCE -I ../../src/include/parser -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o value.o value.c
    gcc -DHAVE_CONFIG_H -I. -I../../src/include  -D_GNU_SOURCE -I ../../src/include/parser -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o ../../src/utils/mmgr/mcxt.o ../../src/utils/mmgr/mcxt.c
    gcc -DHAVE_CONFIG_H -I. -I../../src/include  -D_GNU_SOURCE -I ../../src/include/parser -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o ../../src/utils/mmgr/aset.o ../../src/utils/mmgr/aset.c
    gcc -DHAVE_CONFIG_H -I. -I../../src/include  -D_GNU_SOURCE -I ../../src/include/parser -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o ../../src/utils/error/elog.o ../../src/utils/error/elog.c
    gcc -DHAVE_CONFIG_H -I. -I../../src/include  -D_GNU_SOURCE -I ../../src/include/parser -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o wchar.o wchar.c
    gcc -DHAVE_CONFIG_H -I. -I../../src/include  -D_GNU_SOURCE -I ../../src/include/parser -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o scan.o scan.c
    rm -f libsql-parser.a
    ar cru libsql-parser.a copyfuncs.o gram.o keywords.o list.o makefuncs.o nodes.o outfuncs.o parser.o pool_string.o scansup.o stringinfo.o value.o ../../src/utils/mmgr/mcxt.o ../../src/utils/mmgr/aset.o ../../src/utils/error/elog.o wchar.o scan.o 
    ranlib libsql-parser.a
    make[3]: 디렉터리 '/home/bylee/install/pgpool2-4_0_1/src/parser' 들어감
    make[3]: 'install-exec-am'을(를) 위해 할 일이 없습니다.
    make[3]: 'install-data-am'을(를) 위해 할 일이 없습니다.
    make[3]: 디렉터리 '/home/bylee/install/pgpool2-4_0_1/src/parser' 나감
    make[2]: 디렉터리 '/home/bylee/install/pgpool2-4_0_1/src/parser' 나감
    Making install in libs
    make[2]: 디렉터리 '/home/bylee/install/pgpool2-4_0_1/src/libs' 들어감
    Making install in pcp
    make[3]: 디렉터리 '/home/bylee/install/pgpool2-4_0_1/src/libs/pcp' 들어감
    /bin/sh ../../../libtool  --tag=CC   --mode=compile gcc -DHAVE_CONFIG_H -I. -I../../../src/include  -D_GNU_SOURCE -DPOOL_PRIVATE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o pcp.lo pcp.c
    libtool: compile:  gcc -DHAVE_CONFIG_H -I. -I../../../src/include -D_GNU_SOURCE -DPOOL_PRIVATE -I /home/bylee/install/agensgraph/include -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c pcp.c  -fPIC -DPIC -o .libs/pcp.o
    libtool: compile:  gcc -DHAVE_CONFIG_H -I. -I../../../src/include -D_GNU_SOURCE -DPOOL_PRIVATE -I /home/bylee/install/agensgraph/include -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c pcp.c -o pcp.o >/dev/null 2>&1
    /bin/sh ../../../libtool  --tag=CC   --mode=compile gcc -DHAVE_CONFIG_H -I. -I../../../src/include  -D_GNU_SOURCE -DPOOL_PRIVATE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o ../../utils/pool_path.lo ../../utils/pool_path.c
    libtool: compile:  gcc -DHAVE_CONFIG_H -I. -I../../../src/include -D_GNU_SOURCE -DPOOL_PRIVATE -I /home/bylee/install/agensgraph/include -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c ../../utils/pool_path.c  -fPIC -DPIC -o ../../utils/.libs/pool_path.o
    libtool: compile:  gcc -DHAVE_CONFIG_H -I. -I../../../src/include -D_GNU_SOURCE -DPOOL_PRIVATE -I /home/bylee/install/agensgraph/include -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c ../../utils/pool_path.c -o ../../utils/pool_path.o >/dev/null 2>&1
    /bin/sh ../../../libtool  --tag=CC   --mode=compile gcc -DHAVE_CONFIG_H -I. -I../../../src/include  -D_GNU_SOURCE -DPOOL_PRIVATE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o ../../tools/fe_port.lo ../../tools/fe_port.c
    libtool: compile:  gcc -DHAVE_CONFIG_H -I. -I../../../src/include -D_GNU_SOURCE -DPOOL_PRIVATE -I /home/bylee/install/agensgraph/include -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c ../../tools/fe_port.c  -fPIC -DPIC -o ../../tools/.libs/fe_port.o
    libtool: compile:  gcc -DHAVE_CONFIG_H -I. -I../../../src/include -D_GNU_SOURCE -DPOOL_PRIVATE -I /home/bylee/install/agensgraph/include -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c ../../tools/fe_port.c -o ../../tools/fe_port.o >/dev/null 2>&1
    /bin/sh ../../../libtool  --tag=CC   --mode=compile gcc -DHAVE_CONFIG_H -I. -I../../../src/include  -D_GNU_SOURCE -DPOOL_PRIVATE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o ../../tools/fe_memutils.lo ../../tools/fe_memutils.c
    libtool: compile:  gcc -DHAVE_CONFIG_H -I. -I../../../src/include -D_GNU_SOURCE -DPOOL_PRIVATE -I /home/bylee/install/agensgraph/include -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c ../../tools/fe_memutils.c  -fPIC -DPIC -o ../../tools/.libs/fe_memutils.o
    libtool: compile:  gcc -DHAVE_CONFIG_H -I. -I../../../src/include -D_GNU_SOURCE -DPOOL_PRIVATE -I /home/bylee/install/agensgraph/include -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c ../../tools/fe_memutils.c -o ../../tools/fe_memutils.o >/dev/null 2>&1
    /bin/sh ../../../libtool  --tag=CC   --mode=compile gcc -DHAVE_CONFIG_H -I. -I../../../src/include  -D_GNU_SOURCE -DPOOL_PRIVATE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o ../../utils/strlcpy.lo ../../utils/strlcpy.c
    libtool: compile:  gcc -DHAVE_CONFIG_H -I. -I../../../src/include -D_GNU_SOURCE -DPOOL_PRIVATE -I /home/bylee/install/agensgraph/include -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c ../../utils/strlcpy.c  -fPIC -DPIC -o ../../utils/.libs/strlcpy.o
    libtool: compile:  gcc -DHAVE_CONFIG_H -I. -I../../../src/include -D_GNU_SOURCE -DPOOL_PRIVATE -I /home/bylee/install/agensgraph/include -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c ../../utils/strlcpy.c -o ../../utils/strlcpy.o >/dev/null 2>&1
    rm -f pcp_stream.c && ln -s ../../../src/utils/pcp/pcp_stream.c .
    /bin/sh ../../../libtool  --tag=CC   --mode=compile gcc -DHAVE_CONFIG_H -I. -I../../../src/include  -D_GNU_SOURCE -DPOOL_PRIVATE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o pcp_stream.lo pcp_stream.c
    libtool: compile:  gcc -DHAVE_CONFIG_H -I. -I../../../src/include -D_GNU_SOURCE -DPOOL_PRIVATE -I /home/bylee/install/agensgraph/include -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c pcp_stream.c  -fPIC -DPIC -o .libs/pcp_stream.o
    libtool: compile:  gcc -DHAVE_CONFIG_H -I. -I../../../src/include -D_GNU_SOURCE -DPOOL_PRIVATE -I /home/bylee/install/agensgraph/include -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c pcp_stream.c -o pcp_stream.o >/dev/null 2>&1
    rm -f md5.c && ln -s ../../../src/auth/md5.c .
    /bin/sh ../../../libtool  --tag=CC   --mode=compile gcc -DHAVE_CONFIG_H -I. -I../../../src/include  -D_GNU_SOURCE -DPOOL_PRIVATE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o md5.lo md5.c
    libtool: compile:  gcc -DHAVE_CONFIG_H -I. -I../../../src/include -D_GNU_SOURCE -DPOOL_PRIVATE -I /home/bylee/install/agensgraph/include -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c md5.c  -fPIC -DPIC -o .libs/md5.o
    libtool: compile:  gcc -DHAVE_CONFIG_H -I. -I../../../src/include -D_GNU_SOURCE -DPOOL_PRIVATE -I /home/bylee/install/agensgraph/include -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c md5.c -o md5.o >/dev/null 2>&1
    rm -f json.c && ln -s ../../../src/utils/json.c .
    /bin/sh ../../../libtool  --tag=CC   --mode=compile gcc -DHAVE_CONFIG_H -I. -I../../../src/include  -D_GNU_SOURCE -DPOOL_PRIVATE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o json.lo json.c
    libtool: compile:  gcc -DHAVE_CONFIG_H -I. -I../../../src/include -D_GNU_SOURCE -DPOOL_PRIVATE -I /home/bylee/install/agensgraph/include -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c json.c  -fPIC -DPIC -o .libs/json.o
    libtool: compile:  gcc -DHAVE_CONFIG_H -I. -I../../../src/include -D_GNU_SOURCE -DPOOL_PRIVATE -I /home/bylee/install/agensgraph/include -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c json.c -o json.o >/dev/null 2>&1
    /bin/sh ../../../libtool  --tag=CC   --mode=link gcc  -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -version-info 1:0:0 -L//usr/lib/jvm/java-1.8.0-openjdk-1.8.0.161-0.b14.fc27.x86_64/jre/lib/amd64/server/ -o libpcp.la -rpath /home/bylee/install/pgpool2-4_0_1/lib pcp.lo ../../utils/pool_path.lo ../../tools/fe_port.lo ../../tools/fe_memutils.lo ../../utils/strlcpy.lo pcp_stream.lo md5.lo json.lo  -lcrypt -lresolv -lnsl -lm
    libtool: link: gcc -shared  -fPIC -DPIC  .libs/pcp.o ../../utils/.libs/pool_path.o ../../tools/.libs/fe_port.o ../../tools/.libs/fe_memutils.o ../../utils/.libs/strlcpy.o .libs/pcp_stream.o .libs/md5.o .libs/json.o   -L//usr/lib/jvm/java-1.8.0-openjdk-1.8.0.161-0.b14.fc27.x86_64/jre/lib/amd64/server/ -lcrypt -lresolv -lnsl -lm  -O2   -Wl,-soname -Wl,libpcp.so.1 -o .libs/libpcp.so.1.0.0
    libtool: link: (cd ".libs" && rm -f "libpcp.so.1" && ln -s "libpcp.so.1.0.0" "libpcp.so.1")
    libtool: link: (cd ".libs" && rm -f "libpcp.so" && ln -s "libpcp.so.1.0.0" "libpcp.so")
    libtool: link: ar cru .libs/libpcp.a  pcp.o ../../utils/pool_path.o ../../tools/fe_port.o ../../tools/fe_memutils.o ../../utils/strlcpy.o pcp_stream.o md5.o json.o
    libtool: link: ranlib .libs/libpcp.a
    libtool: link: ( cd ".libs" && rm -f "libpcp.la" && ln -s "../libpcp.la" "libpcp.la" )
    make[4]: 디렉터리 '/home/bylee/install/pgpool2-4_0_1/src/libs/pcp' 들어감
     /usr/bin/mkdir -p '/home/bylee/install/pgpool2-4_0_1/lib'
     /bin/sh ../../../libtool   --mode=install /usr/bin/install -c   libpcp.la '/home/bylee/install/pgpool2-4_0_1/lib'
    libtool: install: /usr/bin/install -c .libs/libpcp.so.1.0.0 /home/bylee/install/pgpool2-4_0_1/lib/libpcp.so.1.0.0
    libtool: install: (cd /home/bylee/install/pgpool2-4_0_1/lib && { ln -s -f libpcp.so.1.0.0 libpcp.so.1 || { rm -f libpcp.so.1 && ln -s libpcp.so.1.0.0 libpcp.so.1; }; })
    libtool: install: (cd /home/bylee/install/pgpool2-4_0_1/lib && { ln -s -f libpcp.so.1.0.0 libpcp.so || { rm -f libpcp.so && ln -s libpcp.so.1.0.0 libpcp.so; }; })
    libtool: install: /usr/bin/install -c .libs/libpcp.lai /home/bylee/install/pgpool2-4_0_1/lib/libpcp.la
    libtool: install: /usr/bin/install -c .libs/libpcp.a /home/bylee/install/pgpool2-4_0_1/lib/libpcp.a
    libtool: install: chmod 644 /home/bylee/install/pgpool2-4_0_1/lib/libpcp.a
    libtool: install: ranlib /home/bylee/install/pgpool2-4_0_1/lib/libpcp.a
    libtool: finish: PATH="/home/bylee/perl5/bin:/home/bylee/.pyenv/plugins/pyenv-virtualenv/shims:/home/bylee/.pyenv/shims:/home/bylee/.pyenv/bin:/home/bylee/install/agensgraph/bin:/home/bylee/install/hadoop/hadoop-3.1.1/sbin:/home/bylee/install/hadoop/hadoop-3.1.1/bin:/home/bylee/install/hadoop/db-derby-10.14.2.0-bin/bin:/home/bylee/install/hadoop/apache-hive-3.1.0-bin/bin:/home/bylee/perl5/bin:/home/bylee/.pyenv/plugins/pyenv-virtualenv/shims:/home/bylee/.pyenv/shims:/home/bylee/.pyenv/bin:/home/bylee/install/agensgraph/bin:/home/bylee/install/hadoop/hadoop-3.1.1/sbin:/home/bylee/install/hadoop/hadoop-3.1.1/bin:/home/bylee/install/hadoop/db-derby-10.14.2.0-bin/bin:/home/bylee/install/hadoop/apache-hive-3.1.0-bin/bin:/usr/local/bin:/usr/local/sbin:/usr/bin:/usr/sbin:/home/bylee/.local/bin:/home/bylee/bin:/sbin" ldconfig -n /home/bylee/install/pgpool2-4_0_1/lib
    ----------------------------------------------------------------------
    Libraries have been installed in:
       /home/bylee/install/pgpool2-4_0_1/lib
     
    If you ever happen to want to link against installed libraries
    in a given directory, LIBDIR, you must either use libtool, and
    specify the full pathname of the library, or use the `-LLIBDIR'
    flag during linking and do at least one of the following:
       - add LIBDIR to the `LD_LIBRARY_PATH' environment variable
         during execution
       - add LIBDIR to the `LD_RUN_PATH' environment variable
         during linking
       - use the `-Wl,-rpath -Wl,LIBDIR' linker flag
       - have your system administrator add LIBDIR to `/etc/ld.so.conf'
     
    See any operating system documentation about shared libraries for
    more information, such as the ld(1) and ld.so(8) manual pages.
    ----------------------------------------------------------------------
     /usr/bin/mkdir -p '/home/bylee/install/pgpool2-4_0_1/include'
     /usr/bin/install -c -m 644 ../../../src/include/pcp/pcp.h ../../../src/include/pcp/libpcp_ext.h ../../../src/include/pool_type.h ../../../src/include/utils/pool_process_reporting.h '/home/bylee/install/pgpool2-4_0_1/include'
    make[4]: 디렉터리 '/home/bylee/install/pgpool2-4_0_1/src/libs/pcp' 나감
    make[3]: 디렉터리 '/home/bylee/install/pgpool2-4_0_1/src/libs/pcp' 나감
    make[3]: 디렉터리 '/home/bylee/install/pgpool2-4_0_1/src/libs' 들어감
    make[4]: 디렉터리 '/home/bylee/install/pgpool2-4_0_1/src/libs' 들어감
    make[4]: 'install-exec-am'을(를) 위해 할 일이 없습니다.
    make[4]: 'install-data-am'을(를) 위해 할 일이 없습니다.
    make[4]: 디렉터리 '/home/bylee/install/pgpool2-4_0_1/src/libs' 나감
    make[3]: 디렉터리 '/home/bylee/install/pgpool2-4_0_1/src/libs' 나감
    make[2]: 디렉터리 '/home/bylee/install/pgpool2-4_0_1/src/libs' 나감
    Making install in watchdog
    make[2]: 디렉터리 '/home/bylee/install/pgpool2-4_0_1/src/watchdog' 들어감
    gcc -DHAVE_CONFIG_H -I. -I../../src/include  -D_GNU_SOURCE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o watchdog.o watchdog.c
    watchdog.c: In function 'watchdog_main':
    watchdog.c:681:74: warning: '%s' directive output may be truncated writing up to 64 bytes into a region of size between 60 and 124 [-Wformat-truncation=]
       snprintf(g_cluster.localNode->nodeName, WD_MAX_HOST_NAMELEN, "%s:%d %s %s",
                                                                              ^~
    watchdog.c:685:6:
          unameData.nodename);
          ~~~~~~~~~                                                           
    watchdog.c:681:3: note: 'snprintf' output 5 or more bytes (assuming 133) into a destination of size 128
       snprintf(g_cluster.localNode->nodeName, WD_MAX_HOST_NAMELEN, "%s:%d %s %s",
       ^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
          pool_config->wd_hostname,
          ~~~~~~~~~~~~~~~~~~~~~~~~~
          pool_config->port,
          ~~~~~~~~~~~~~~~~~~
          unameData.sysname,
          ~~~~~~~~~~~~~~~~~~
          unameData.nodename);
          ~~~~~~~~~~~~~~~~~~~
    gcc -DHAVE_CONFIG_H -I. -I../../src/include  -D_GNU_SOURCE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o wd_if.o wd_if.c
    gcc -DHAVE_CONFIG_H -I. -I../../src/include  -D_GNU_SOURCE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o wd_lifecheck.o wd_lifecheck.c
    gcc -DHAVE_CONFIG_H -I. -I../../src/include  -D_GNU_SOURCE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o wd_commands.o wd_commands.c
    gcc -DHAVE_CONFIG_H -I. -I../../src/include  -D_GNU_SOURCE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o wd_json_data.o wd_json_data.c
    wd_json_data.c: In function 'parse_wd_node_function_json':
    wd_json_data.c:799:48: warning: passing argument 3 of 'json_get_int_value_for_key' from incompatible pointer type [-Wincompatible-pointer-types]
      if (json_get_int_value_for_key(root, "Flags", flags))
                                                    ^~~~~
    In file included from wd_json_data.c:28:0:
    ../../src/include/utils/json.h:315:7: note: expected 'int *' but argument is of type 'unsigned char *'
     int   json_get_int_value_for_key(json_value * source, const char *key, int *value);
           ^~~~~~~~~~~~~~~~~~~~~~~~~~
    gcc -DHAVE_CONFIG_H -I. -I../../src/include  -D_GNU_SOURCE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o wd_ping.o wd_ping.c
    gcc -DHAVE_CONFIG_H -I. -I../../src/include  -D_GNU_SOURCE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o wd_heartbeat.o wd_heartbeat.c
    gcc -DHAVE_CONFIG_H -I. -I../../src/include  -D_GNU_SOURCE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o wd_utils.o wd_utils.c
    gcc -DHAVE_CONFIG_H -I. -I../../src/include  -D_GNU_SOURCE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o wd_escalation.o wd_escalation.c
    rm -f lib-watchdog.a
    ar cru lib-watchdog.a watchdog.o wd_if.o wd_lifecheck.o wd_commands.o wd_json_data.o wd_ping.o wd_heartbeat.o wd_utils.o wd_escalation.o
    ranlib lib-watchdog.a
    make[3]: 디렉터리 '/home/bylee/install/pgpool2-4_0_1/src/watchdog' 들어감
    make[3]: 'install-exec-am'을(를) 위해 할 일이 없습니다.
    make[3]: 'install-data-am'을(를) 위해 할 일이 없습니다.
    make[3]: 디렉터리 '/home/bylee/install/pgpool2-4_0_1/src/watchdog' 나감
    make[2]: 디렉터리 '/home/bylee/install/pgpool2-4_0_1/src/watchdog' 나감
    Making install in .
    make[2]: 디렉터리 '/home/bylee/install/pgpool2-4_0_1/src' 들어감
    gcc -DHAVE_CONFIG_H -DDEFAULT_CONFIGDIR=\"/home/bylee/install/pgpool2-4_0_1/etc\" -DHEALTHCHECK_OPTS=0 -I. -I../src/include  -D_GNU_SOURCE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o main/main.o main/main.c
    main/main.c: In function 'main':
    main/main.c:209:7: warning: "/*" within comment [-Wcomment]
       /*  /* global ssl init */ */
             
    main/main.c:216:14: warning: "/*" within comment [-Wcomment]
        /* #endif /* USE_SSL */ */
                    
    gcc -DHAVE_CONFIG_H -DDEFAULT_CONFIGDIR=\"/home/bylee/install/pgpool2-4_0_1/etc\" -DHEALTHCHECK_OPTS=0 -I. -I../src/include  -D_GNU_SOURCE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o main/pool_globals.o main/pool_globals.c
    gcc -DHAVE_CONFIG_H -DDEFAULT_CONFIGDIR=\"/home/bylee/install/pgpool2-4_0_1/etc\" -DHEALTHCHECK_OPTS=0 -I. -I../src/include  -D_GNU_SOURCE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o main/pgpool_main.o main/pgpool_main.c
    gcc -DHAVE_CONFIG_H -DDEFAULT_CONFIGDIR=\"/home/bylee/install/pgpool2-4_0_1/etc\" -DHEALTHCHECK_OPTS=0 -I. -I../src/include  -D_GNU_SOURCE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o main/health_check.o main/health_check.c
    gcc -DHAVE_CONFIG_H -DDEFAULT_CONFIGDIR=\"/home/bylee/install/pgpool2-4_0_1/etc\" -DHEALTHCHECK_OPTS=0 -I. -I../src/include  -D_GNU_SOURCE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o config/pool_config.o config/pool_config.c
    gcc -DHAVE_CONFIG_H -DDEFAULT_CONFIGDIR=\"/home/bylee/install/pgpool2-4_0_1/etc\" -DHEALTHCHECK_OPTS=0 -I. -I../src/include  -D_GNU_SOURCE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o config/pool_config_variables.o config/pool_config_variables.c
    gcc -DHAVE_CONFIG_H -DDEFAULT_CONFIGDIR=\"/home/bylee/install/pgpool2-4_0_1/etc\" -DHEALTHCHECK_OPTS=0 -I. -I../src/include  -D_GNU_SOURCE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o pcp_con/pcp_child.o pcp_con/pcp_child.c
    gcc -DHAVE_CONFIG_H -DDEFAULT_CONFIGDIR=\"/home/bylee/install/pgpool2-4_0_1/etc\" -DHEALTHCHECK_OPTS=0 -I. -I../src/include  -D_GNU_SOURCE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o pcp_con/pcp_worker.o pcp_con/pcp_worker.c
    gcc -DHAVE_CONFIG_H -DDEFAULT_CONFIGDIR=\"/home/bylee/install/pgpool2-4_0_1/etc\" -DHEALTHCHECK_OPTS=0 -I. -I../src/include  -D_GNU_SOURCE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o pcp_con/recovery.o pcp_con/recovery.c
    gcc -DHAVE_CONFIG_H -DDEFAULT_CONFIGDIR=\"/home/bylee/install/pgpool2-4_0_1/etc\" -DHEALTHCHECK_OPTS=0 -I. -I../src/include  -D_GNU_SOURCE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o auth/md5.o auth/md5.c
    gcc -DHAVE_CONFIG_H -DDEFAULT_CONFIGDIR=\"/home/bylee/install/pgpool2-4_0_1/etc\" -DHEALTHCHECK_OPTS=0 -I. -I../src/include  -D_GNU_SOURCE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o auth/pool_auth.o auth/pool_auth.c
    gcc -DHAVE_CONFIG_H -DDEFAULT_CONFIGDIR=\"/home/bylee/install/pgpool2-4_0_1/etc\" -DHEALTHCHECK_OPTS=0 -I. -I../src/include  -D_GNU_SOURCE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o auth/pool_passwd.o auth/pool_passwd.c
    gcc -DHAVE_CONFIG_H -DDEFAULT_CONFIGDIR=\"/home/bylee/install/pgpool2-4_0_1/etc\" -DHEALTHCHECK_OPTS=0 -I. -I../src/include  -D_GNU_SOURCE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o auth/pool_hba.o auth/pool_hba.c
    auth/pool_hba.c:2068:20: warning: 'CheckUserExist' defined but not used [-Wunused-function]
     static POOL_STATUS CheckUserExist(char *username)
                        ^~~~~~~~~~~~~~
    gcc -DHAVE_CONFIG_H -DDEFAULT_CONFIGDIR=\"/home/bylee/install/pgpool2-4_0_1/etc\" -DHEALTHCHECK_OPTS=0 -I. -I../src/include  -D_GNU_SOURCE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o auth/auth-scram.o auth/auth-scram.c
    gcc -DHAVE_CONFIG_H -DDEFAULT_CONFIGDIR=\"/home/bylee/install/pgpool2-4_0_1/etc\" -DHEALTHCHECK_OPTS=0 -I. -I../src/include  -D_GNU_SOURCE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o protocol/pool_proto2.o protocol/pool_proto2.c
    gcc -DHAVE_CONFIG_H -DDEFAULT_CONFIGDIR=\"/home/bylee/install/pgpool2-4_0_1/etc\" -DHEALTHCHECK_OPTS=0 -I. -I../src/include  -D_GNU_SOURCE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o protocol/child.o protocol/child.c
    gcc -DHAVE_CONFIG_H -DDEFAULT_CONFIGDIR=\"/home/bylee/install/pgpool2-4_0_1/etc\" -DHEALTHCHECK_OPTS=0 -I. -I../src/include  -D_GNU_SOURCE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o protocol/pool_process_query.o protocol/pool_process_query.c
    gcc -DHAVE_CONFIG_H -DDEFAULT_CONFIGDIR=\"/home/bylee/install/pgpool2-4_0_1/etc\" -DHEALTHCHECK_OPTS=0 -I. -I../src/include  -D_GNU_SOURCE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o protocol/pool_connection_pool.o protocol/pool_connection_pool.c
    gcc -DHAVE_CONFIG_H -DDEFAULT_CONFIGDIR=\"/home/bylee/install/pgpool2-4_0_1/etc\" -DHEALTHCHECK_OPTS=0 -I. -I../src/include  -D_GNU_SOURCE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o protocol/pool_proto_modules.o protocol/pool_proto_modules.c
    gcc -DHAVE_CONFIG_H -DDEFAULT_CONFIGDIR=\"/home/bylee/install/pgpool2-4_0_1/etc\" -DHEALTHCHECK_OPTS=0 -I. -I../src/include  -D_GNU_SOURCE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o query_cache/pool_memqcache.o query_cache/pool_memqcache.c
    gcc -DHAVE_CONFIG_H -DDEFAULT_CONFIGDIR=\"/home/bylee/install/pgpool2-4_0_1/etc\" -DHEALTHCHECK_OPTS=0 -I. -I../src/include  -D_GNU_SOURCE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o protocol/CommandComplete.o protocol/CommandComplete.c
    gcc -DHAVE_CONFIG_H -DDEFAULT_CONFIGDIR=\"/home/bylee/install/pgpool2-4_0_1/etc\" -DHEALTHCHECK_OPTS=0 -I. -I../src/include  -D_GNU_SOURCE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o context/pool_session_context.o context/pool_session_context.c
    gcc -DHAVE_CONFIG_H -DDEFAULT_CONFIGDIR=\"/home/bylee/install/pgpool2-4_0_1/etc\" -DHEALTHCHECK_OPTS=0 -I. -I../src/include  -D_GNU_SOURCE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o context/pool_process_context.o context/pool_process_context.c
    gcc -DHAVE_CONFIG_H -DDEFAULT_CONFIGDIR=\"/home/bylee/install/pgpool2-4_0_1/etc\" -DHEALTHCHECK_OPTS=0 -I. -I../src/include  -D_GNU_SOURCE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o context/pool_query_context.o context/pool_query_context.c
    gcc -DHAVE_CONFIG_H -DDEFAULT_CONFIGDIR=\"/home/bylee/install/pgpool2-4_0_1/etc\" -DHEALTHCHECK_OPTS=0 -I. -I../src/include  -D_GNU_SOURCE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o streaming_replication/pool_worker_child.o streaming_replication/pool_worker_child.c
    gcc -DHAVE_CONFIG_H -DDEFAULT_CONFIGDIR=\"/home/bylee/install/pgpool2-4_0_1/etc\" -DHEALTHCHECK_OPTS=0 -I. -I../src/include  -D_GNU_SOURCE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o rewrite/pool_timestamp.o rewrite/pool_timestamp.c
    gcc -DHAVE_CONFIG_H -DDEFAULT_CONFIGDIR=\"/home/bylee/install/pgpool2-4_0_1/etc\" -DHEALTHCHECK_OPTS=0 -I. -I../src/include  -D_GNU_SOURCE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o rewrite/pool_lobj.o rewrite/pool_lobj.c
    gcc -DHAVE_CONFIG_H -DDEFAULT_CONFIGDIR=\"/home/bylee/install/pgpool2-4_0_1/etc\" -DHEALTHCHECK_OPTS=0 -I. -I../src/include  -D_GNU_SOURCE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o utils/pool_select_walker.o utils/pool_select_walker.c
    gcc -DHAVE_CONFIG_H -DDEFAULT_CONFIGDIR=\"/home/bylee/install/pgpool2-4_0_1/etc\" -DHEALTHCHECK_OPTS=0 -I. -I../src/include  -D_GNU_SOURCE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o utils/psprintf.o utils/psprintf.c
    gcc -DHAVE_CONFIG_H -DDEFAULT_CONFIGDIR=\"/home/bylee/install/pgpool2-4_0_1/etc\" -DHEALTHCHECK_OPTS=0 -I. -I../src/include  -D_GNU_SOURCE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o utils/pool_params.o utils/pool_params.c
    gcc -DHAVE_CONFIG_H -DDEFAULT_CONFIGDIR=\"/home/bylee/install/pgpool2-4_0_1/etc\" -DHEALTHCHECK_OPTS=0 -I. -I../src/include  -D_GNU_SOURCE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o utils/ps_status.o utils/ps_status.c
    gcc -DHAVE_CONFIG_H -DDEFAULT_CONFIGDIR=\"/home/bylee/install/pgpool2-4_0_1/etc\" -DHEALTHCHECK_OPTS=0 -I. -I../src/include  -D_GNU_SOURCE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o utils/pool_shmem.o utils/pool_shmem.c
    gcc -DHAVE_CONFIG_H -DDEFAULT_CONFIGDIR=\"/home/bylee/install/pgpool2-4_0_1/etc\" -DHEALTHCHECK_OPTS=0 -I. -I../src/include  -D_GNU_SOURCE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o utils/pool_sema.o utils/pool_sema.c
    gcc -DHAVE_CONFIG_H -DDEFAULT_CONFIGDIR=\"/home/bylee/install/pgpool2-4_0_1/etc\" -DHEALTHCHECK_OPTS=0 -I. -I../src/include  -D_GNU_SOURCE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o utils/pool_signal.o utils/pool_signal.c
    gcc -DHAVE_CONFIG_H -DDEFAULT_CONFIGDIR=\"/home/bylee/install/pgpool2-4_0_1/etc\" -DHEALTHCHECK_OPTS=0 -I. -I../src/include  -D_GNU_SOURCE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o utils/pool_ip.o utils/pool_ip.c
    gcc -DHAVE_CONFIG_H -DDEFAULT_CONFIGDIR=\"/home/bylee/install/pgpool2-4_0_1/etc\" -DHEALTHCHECK_OPTS=0 -I. -I../src/include  -D_GNU_SOURCE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o utils/pool_relcache.o utils/pool_relcache.c
    gcc -DHAVE_CONFIG_H -DDEFAULT_CONFIGDIR=\"/home/bylee/install/pgpool2-4_0_1/etc\" -DHEALTHCHECK_OPTS=0 -I. -I../src/include  -D_GNU_SOURCE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o utils/pool_process_reporting.o utils/pool_process_reporting.c
    utils/pool_process_reporting.c: In function 'get_nodes':
    utils/pool_process_reporting.c:1199:52: warning: '%d' directive output may be truncated writing between 1 and 10 bytes into a region of size 4 [-Wformat-truncation=]
       snprintf(nodes[i].node_id, POOLCONFIG_MAXIDLEN, "%d", i);
                                                        ^~
    utils/pool_process_reporting.c:1199:51: note: directive argument in the range [0, 2147483647]
       snprintf(nodes[i].node_id, POOLCONFIG_MAXIDLEN, "%d", i);
                                                       ^~~~
    utils/pool_process_reporting.c:1199:3: note: 'snprintf' output between 2 and 11 bytes into a destination of size 4
       snprintf(nodes[i].node_id, POOLCONFIG_MAXIDLEN, "%d", i);
       ^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    gcc -DHAVE_CONFIG_H -DDEFAULT_CONFIGDIR=\"/home/bylee/install/pgpool2-4_0_1/etc\" -DHEALTHCHECK_OPTS=0 -I. -I../src/include  -D_GNU_SOURCE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o utils/pool_ssl.o utils/pool_ssl.c
    gcc -DHAVE_CONFIG_H -DDEFAULT_CONFIGDIR=\"/home/bylee/install/pgpool2-4_0_1/etc\" -DHEALTHCHECK_OPTS=0 -I. -I../src/include  -D_GNU_SOURCE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o utils/pool_stream.o utils/pool_stream.c
    gcc -DHAVE_CONFIG_H -DDEFAULT_CONFIGDIR=\"/home/bylee/install/pgpool2-4_0_1/etc\" -DHEALTHCHECK_OPTS=0 -I. -I../src/include  -D_GNU_SOURCE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o utils/getopt_long.o utils/getopt_long.c
    gcc -DHAVE_CONFIG_H -DDEFAULT_CONFIGDIR=\"/home/bylee/install/pgpool2-4_0_1/etc\" -DHEALTHCHECK_OPTS=0 -I. -I../src/include  -D_GNU_SOURCE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o utils/error/assert.o utils/error/assert.c
    gcc -DHAVE_CONFIG_H -DDEFAULT_CONFIGDIR=\"/home/bylee/install/pgpool2-4_0_1/etc\" -DHEALTHCHECK_OPTS=0 -I. -I../src/include  -D_GNU_SOURCE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o utils/pcp/pcp_stream.o utils/pcp/pcp_stream.c
    gcc -DHAVE_CONFIG_H -DDEFAULT_CONFIGDIR=\"/home/bylee/install/pgpool2-4_0_1/etc\" -DHEALTHCHECK_OPTS=0 -I. -I../src/include  -D_GNU_SOURCE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o utils/regex_array.o utils/regex_array.c
    gcc -DHAVE_CONFIG_H -DDEFAULT_CONFIGDIR=\"/home/bylee/install/pgpool2-4_0_1/etc\" -DHEALTHCHECK_OPTS=0 -I. -I../src/include  -D_GNU_SOURCE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o utils/json_writer.o utils/json_writer.c
    gcc -DHAVE_CONFIG_H -DDEFAULT_CONFIGDIR=\"/home/bylee/install/pgpool2-4_0_1/etc\" -DHEALTHCHECK_OPTS=0 -I. -I../src/include  -D_GNU_SOURCE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o utils/json.o utils/json.c
    gcc -DHAVE_CONFIG_H -DDEFAULT_CONFIGDIR=\"/home/bylee/install/pgpool2-4_0_1/etc\" -DHEALTHCHECK_OPTS=0 -I. -I../src/include  -D_GNU_SOURCE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o utils/scram-common.o utils/scram-common.c
    gcc -DHAVE_CONFIG_H -DDEFAULT_CONFIGDIR=\"/home/bylee/install/pgpool2-4_0_1/etc\" -DHEALTHCHECK_OPTS=0 -I. -I../src/include  -D_GNU_SOURCE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o utils/base64.o utils/base64.c
    gcc -DHAVE_CONFIG_H -DDEFAULT_CONFIGDIR=\"/home/bylee/install/pgpool2-4_0_1/etc\" -DHEALTHCHECK_OPTS=0 -I. -I../src/include  -D_GNU_SOURCE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o utils/sha2.o utils/sha2.c
    gcc -DHAVE_CONFIG_H -DDEFAULT_CONFIGDIR=\"/home/bylee/install/pgpool2-4_0_1/etc\" -DHEALTHCHECK_OPTS=0 -I. -I../src/include  -D_GNU_SOURCE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o utils/ssl_utils.o utils/ssl_utils.c
    gcc -DHAVE_CONFIG_H -DDEFAULT_CONFIGDIR=\"/home/bylee/install/pgpool2-4_0_1/etc\" -DHEALTHCHECK_OPTS=0 -I. -I../src/include  -D_GNU_SOURCE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o utils/statistics.o utils/statistics.c
    /bin/sh ../libtool  --tag=CC   --mode=link gcc  -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -rpath /home/bylee/install/agensgraph/lib -rpath /home/bylee/install/pgpool2-4_0_1/lib -L//usr/lib/jvm/java-1.8.0-openjdk-1.8.0.161-0.b14.fc27.x86_64/jre/lib/amd64/server/ -o pgpool main/main.o main/pool_globals.o main/pgpool_main.o main/health_check.o config/pool_config.o config/pool_config_variables.o pcp_con/pcp_child.o pcp_con/pcp_worker.o pcp_con/recovery.o auth/md5.o auth/pool_auth.o auth/pool_passwd.o auth/pool_hba.o auth/auth-scram.o protocol/pool_proto2.o protocol/child.o protocol/pool_process_query.o protocol/pool_connection_pool.o protocol/pool_proto_modules.o query_cache/pool_memqcache.o protocol/CommandComplete.o context/pool_session_context.o context/pool_process_context.o context/pool_query_context.o streaming_replication/pool_worker_child.o rewrite/pool_timestamp.o rewrite/pool_lobj.o utils/pool_select_walker.o utils/strlcpy.o utils/psprintf.o utils/pool_params.o utils/ps_status.o utils/pool_shmem.o utils/pool_sema.o utils/pool_signal.o utils/pool_path.o utils/pool_ip.o utils/pool_relcache.o utils/pool_process_reporting.o utils/pool_ssl.o utils/pool_stream.o utils/getopt_long.o utils/mmgr/mcxt.o utils/mmgr/aset.o utils/error/elog.o utils/error/assert.o utils/pcp/pcp_stream.o utils/regex_array.o utils/json_writer.o utils/json.o utils/scram-common.o utils/base64.o utils/sha2.o utils/ssl_utils.o utils/statistics.o -L/home/bylee/install/agensgraph/lib -lpq parser/libsql-parser.a parser/nodes.o watchdog/lib-watchdog.a -lpthread -lcrypt -lresolv -lnsl -lm
    libtool: link: gcc -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -o pgpool main/main.o main/pool_globals.o main/pgpool_main.o main/health_check.o config/pool_config.o config/pool_config_variables.o pcp_con/pcp_child.o pcp_con/pcp_worker.o pcp_con/recovery.o auth/md5.o auth/pool_auth.o auth/pool_passwd.o auth/pool_hba.o auth/auth-scram.o protocol/pool_proto2.o protocol/child.o protocol/pool_process_query.o protocol/pool_connection_pool.o protocol/pool_proto_modules.o query_cache/pool_memqcache.o protocol/CommandComplete.o context/pool_session_context.o context/pool_process_context.o context/pool_query_context.o streaming_replication/pool_worker_child.o rewrite/pool_timestamp.o rewrite/pool_lobj.o utils/pool_select_walker.o utils/strlcpy.o utils/psprintf.o utils/pool_params.o utils/ps_status.o utils/pool_shmem.o utils/pool_sema.o utils/pool_signal.o utils/pool_path.o utils/pool_ip.o utils/pool_relcache.o utils/pool_process_reporting.o utils/pool_ssl.o utils/pool_stream.o utils/getopt_long.o utils/mmgr/mcxt.o utils/mmgr/aset.o utils/error/elog.o utils/error/assert.o utils/pcp/pcp_stream.o utils/regex_array.o utils/json_writer.o utils/json.o utils/scram-common.o utils/base64.o utils/sha2.o utils/ssl_utils.o utils/statistics.o parser/nodes.o  -L//usr/lib/jvm/java-1.8.0-openjdk-1.8.0.161-0.b14.fc27.x86_64/jre/lib/amd64/server/ -L/home/bylee/install/agensgraph/lib -lpq parser/libsql-parser.a watchdog/lib-watchdog.a -lpthread -lcrypt -lresolv -lnsl -lm -Wl,-rpath -Wl,/home/bylee/install/agensgraph/lib -Wl,-rpath -Wl,/home/bylee/install/pgpool2-4_0_1/lib
    make[3]: 디렉터리 '/home/bylee/install/pgpool2-4_0_1/src' 들어감
     /usr/bin/mkdir -p '/home/bylee/install/pgpool2-4_0_1/bin'
      /bin/sh ../libtool   --mode=install /usr/bin/install -c pgpool '/home/bylee/install/pgpool2-4_0_1/bin'
    libtool: install: /usr/bin/install -c pgpool /home/bylee/install/pgpool2-4_0_1/bin/pgpool
     /usr/bin/mkdir -p '/home/bylee/install/pgpool2-4_0_1/etc'
     /usr/bin/install -c -m 644 sample/pgpool.conf.sample sample/pcp.conf.sample sample/pool_hba.conf.sample sample/pgpool.conf.sample-replication sample/pgpool.conf.sample-master-slave sample/pgpool.conf.sample-stream sample/pgpool.conf.sample-logical '/home/bylee/install/pgpool2-4_0_1/etc'
     /usr/bin/mkdir -p '/home/bylee/install/pgpool2-4_0_1/share/pgpool-II'
     /usr/bin/install -c -m 644 sql/insert_lock.sql sample/pgpool.pam '/home/bylee/install/pgpool2-4_0_1/share/pgpool-II'
    make[3]: 디렉터리 '/home/bylee/install/pgpool2-4_0_1/src' 나감
    make[2]: 디렉터리 '/home/bylee/install/pgpool2-4_0_1/src' 나감
    Making install in tools
    make[2]: 디렉터리 '/home/bylee/install/pgpool2-4_0_1/src/tools' 들어감
    Making install in pcp
    make[3]: 디렉터리 '/home/bylee/install/pgpool2-4_0_1/src/tools/pcp' 들어감
    gcc -DHAVE_CONFIG_H -I. -I../../../src/include  -D_GNU_SOURCE -DPOOL_PRIVATE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o pcp_frontend_client.o pcp_frontend_client.c
    gcc -DHAVE_CONFIG_H -I. -I../../../src/include  -D_GNU_SOURCE -DPOOL_PRIVATE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o ../../utils/sprompt.o ../../utils/sprompt.c
    /bin/sh ../../../libtool  --tag=CC   --mode=link gcc  -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing  -L//usr/lib/jvm/java-1.8.0-openjdk-1.8.0.161-0.b14.fc27.x86_64/jre/lib/amd64/server/ -o pcp_stop_pgpool pcp_frontend_client.o ../fe_memutils.o ../../utils/sprompt.o ../../utils/pool_path.o ../../../src/libs/pcp/libpcp.la -lcrypt -lresolv -lnsl -lm
    libtool: link: gcc -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -o .libs/pcp_stop_pgpool pcp_frontend_client.o ../fe_memutils.o ../../utils/sprompt.o ../../utils/pool_path.o  -L//usr/lib/jvm/java-1.8.0-openjdk-1.8.0.161-0.b14.fc27.x86_64/jre/lib/amd64/server/ ../../../src/libs/pcp/.libs/libpcp.so -lcrypt -lresolv -lnsl -lm -Wl,-rpath -Wl,/home/bylee/install/pgpool2-4_0_1/lib
    /bin/sh ../../../libtool  --tag=CC   --mode=link gcc  -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing  -L//usr/lib/jvm/java-1.8.0-openjdk-1.8.0.161-0.b14.fc27.x86_64/jre/lib/amd64/server/ -o pcp_node_count pcp_frontend_client.o ../fe_memutils.o ../../utils/sprompt.o ../../utils/pool_path.o ../../../src/libs/pcp/libpcp.la -lcrypt -lresolv -lnsl -lm
    libtool: link: gcc -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -o .libs/pcp_node_count pcp_frontend_client.o ../fe_memutils.o ../../utils/sprompt.o ../../utils/pool_path.o  -L//usr/lib/jvm/java-1.8.0-openjdk-1.8.0.161-0.b14.fc27.x86_64/jre/lib/amd64/server/ ../../../src/libs/pcp/.libs/libpcp.so -lcrypt -lresolv -lnsl -lm -Wl,-rpath -Wl,/home/bylee/install/pgpool2-4_0_1/lib
    /bin/sh ../../../libtool  --tag=CC   --mode=link gcc  -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing  -L//usr/lib/jvm/java-1.8.0-openjdk-1.8.0.161-0.b14.fc27.x86_64/jre/lib/amd64/server/ -o pcp_node_info pcp_frontend_client.o ../fe_memutils.o ../../utils/sprompt.o ../../utils/pool_path.o ../../../src/libs/pcp/libpcp.la -lcrypt -lresolv -lnsl -lm
    libtool: link: gcc -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -o .libs/pcp_node_info pcp_frontend_client.o ../fe_memutils.o ../../utils/sprompt.o ../../utils/pool_path.o  -L//usr/lib/jvm/java-1.8.0-openjdk-1.8.0.161-0.b14.fc27.x86_64/jre/lib/amd64/server/ ../../../src/libs/pcp/.libs/libpcp.so -lcrypt -lresolv -lnsl -lm -Wl,-rpath -Wl,/home/bylee/install/pgpool2-4_0_1/lib
    /bin/sh ../../../libtool  --tag=CC   --mode=link gcc  -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing  -L//usr/lib/jvm/java-1.8.0-openjdk-1.8.0.161-0.b14.fc27.x86_64/jre/lib/amd64/server/ -o pcp_proc_count pcp_frontend_client.o ../fe_memutils.o ../../utils/sprompt.o ../../utils/pool_path.o ../../../src/libs/pcp/libpcp.la -lcrypt -lresolv -lnsl -lm
    libtool: link: gcc -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -o .libs/pcp_proc_count pcp_frontend_client.o ../fe_memutils.o ../../utils/sprompt.o ../../utils/pool_path.o  -L//usr/lib/jvm/java-1.8.0-openjdk-1.8.0.161-0.b14.fc27.x86_64/jre/lib/amd64/server/ ../../../src/libs/pcp/.libs/libpcp.so -lcrypt -lresolv -lnsl -lm -Wl,-rpath -Wl,/home/bylee/install/pgpool2-4_0_1/lib
    /bin/sh ../../../libtool  --tag=CC   --mode=link gcc  -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing  -L//usr/lib/jvm/java-1.8.0-openjdk-1.8.0.161-0.b14.fc27.x86_64/jre/lib/amd64/server/ -o pcp_proc_info pcp_frontend_client.o ../fe_memutils.o ../../utils/sprompt.o ../../utils/pool_path.o ../../../src/libs/pcp/libpcp.la -lcrypt -lresolv -lnsl -lm
    libtool: link: gcc -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -o .libs/pcp_proc_info pcp_frontend_client.o ../fe_memutils.o ../../utils/sprompt.o ../../utils/pool_path.o  -L//usr/lib/jvm/java-1.8.0-openjdk-1.8.0.161-0.b14.fc27.x86_64/jre/lib/amd64/server/ ../../../src/libs/pcp/.libs/libpcp.so -lcrypt -lresolv -lnsl -lm -Wl,-rpath -Wl,/home/bylee/install/pgpool2-4_0_1/lib
    /bin/sh ../../../libtool  --tag=CC   --mode=link gcc  -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing  -L//usr/lib/jvm/java-1.8.0-openjdk-1.8.0.161-0.b14.fc27.x86_64/jre/lib/amd64/server/ -o pcp_detach_node pcp_frontend_client.o ../fe_memutils.o ../../utils/sprompt.o ../../utils/pool_path.o ../../../src/libs/pcp/libpcp.la -lcrypt -lresolv -lnsl -lm
    libtool: link: gcc -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -o .libs/pcp_detach_node pcp_frontend_client.o ../fe_memutils.o ../../utils/sprompt.o ../../utils/pool_path.o  -L//usr/lib/jvm/java-1.8.0-openjdk-1.8.0.161-0.b14.fc27.x86_64/jre/lib/amd64/server/ ../../../src/libs/pcp/.libs/libpcp.so -lcrypt -lresolv -lnsl -lm -Wl,-rpath -Wl,/home/bylee/install/pgpool2-4_0_1/lib
    /bin/sh ../../../libtool  --tag=CC   --mode=link gcc  -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing  -L//usr/lib/jvm/java-1.8.0-openjdk-1.8.0.161-0.b14.fc27.x86_64/jre/lib/amd64/server/ -o pcp_attach_node pcp_frontend_client.o ../fe_memutils.o ../../utils/sprompt.o ../../utils/pool_path.o ../../../src/libs/pcp/libpcp.la -lcrypt -lresolv -lnsl -lm
    libtool: link: gcc -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -o .libs/pcp_attach_node pcp_frontend_client.o ../fe_memutils.o ../../utils/sprompt.o ../../utils/pool_path.o  -L//usr/lib/jvm/java-1.8.0-openjdk-1.8.0.161-0.b14.fc27.x86_64/jre/lib/amd64/server/ ../../../src/libs/pcp/.libs/libpcp.so -lcrypt -lresolv -lnsl -lm -Wl,-rpath -Wl,/home/bylee/install/pgpool2-4_0_1/lib
    /bin/sh ../../../libtool  --tag=CC   --mode=link gcc  -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing  -L//usr/lib/jvm/java-1.8.0-openjdk-1.8.0.161-0.b14.fc27.x86_64/jre/lib/amd64/server/ -o pcp_recovery_node pcp_frontend_client.o ../fe_memutils.o ../../utils/sprompt.o ../../utils/pool_path.o ../../../src/libs/pcp/libpcp.la -lcrypt -lresolv -lnsl -lm
    libtool: link: gcc -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -o .libs/pcp_recovery_node pcp_frontend_client.o ../fe_memutils.o ../../utils/sprompt.o ../../utils/pool_path.o  -L//usr/lib/jvm/java-1.8.0-openjdk-1.8.0.161-0.b14.fc27.x86_64/jre/lib/amd64/server/ ../../../src/libs/pcp/.libs/libpcp.so -lcrypt -lresolv -lnsl -lm -Wl,-rpath -Wl,/home/bylee/install/pgpool2-4_0_1/lib
    /bin/sh ../../../libtool  --tag=CC   --mode=link gcc  -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing  -L//usr/lib/jvm/java-1.8.0-openjdk-1.8.0.161-0.b14.fc27.x86_64/jre/lib/amd64/server/ -o pcp_promote_node pcp_frontend_client.o ../fe_memutils.o ../../utils/sprompt.o ../../utils/pool_path.o ../../../src/libs/pcp/libpcp.la -lcrypt -lresolv -lnsl -lm
    libtool: link: gcc -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -o .libs/pcp_promote_node pcp_frontend_client.o ../fe_memutils.o ../../utils/sprompt.o ../../utils/pool_path.o  -L//usr/lib/jvm/java-1.8.0-openjdk-1.8.0.161-0.b14.fc27.x86_64/jre/lib/amd64/server/ ../../../src/libs/pcp/.libs/libpcp.so -lcrypt -lresolv -lnsl -lm -Wl,-rpath -Wl,/home/bylee/install/pgpool2-4_0_1/lib
    /bin/sh ../../../libtool  --tag=CC   --mode=link gcc  -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing  -L//usr/lib/jvm/java-1.8.0-openjdk-1.8.0.161-0.b14.fc27.x86_64/jre/lib/amd64/server/ -o pcp_pool_status pcp_frontend_client.o ../fe_memutils.o ../../utils/sprompt.o ../../utils/pool_path.o ../../../src/libs/pcp/libpcp.la -lcrypt -lresolv -lnsl -lm
    libtool: link: gcc -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -o .libs/pcp_pool_status pcp_frontend_client.o ../fe_memutils.o ../../utils/sprompt.o ../../utils/pool_path.o  -L//usr/lib/jvm/java-1.8.0-openjdk-1.8.0.161-0.b14.fc27.x86_64/jre/lib/amd64/server/ ../../../src/libs/pcp/.libs/libpcp.so -lcrypt -lresolv -lnsl -lm -Wl,-rpath -Wl,/home/bylee/install/pgpool2-4_0_1/lib
    /bin/sh ../../../libtool  --tag=CC   --mode=link gcc  -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing  -L//usr/lib/jvm/java-1.8.0-openjdk-1.8.0.161-0.b14.fc27.x86_64/jre/lib/amd64/server/ -o pcp_watchdog_info pcp_frontend_client.o ../fe_memutils.o ../../utils/sprompt.o ../../utils/pool_path.o ../../../src/libs/pcp/libpcp.la -lcrypt -lresolv -lnsl -lm
    libtool: link: gcc -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -o .libs/pcp_watchdog_info pcp_frontend_client.o ../fe_memutils.o ../../utils/sprompt.o ../../utils/pool_path.o  -L//usr/lib/jvm/java-1.8.0-openjdk-1.8.0.161-0.b14.fc27.x86_64/jre/lib/amd64/server/ ../../../src/libs/pcp/.libs/libpcp.so -lcrypt -lresolv -lnsl -lm -Wl,-rpath -Wl,/home/bylee/install/pgpool2-4_0_1/lib
    make[4]: 디렉터리 '/home/bylee/install/pgpool2-4_0_1/src/tools/pcp' 들어감
     /usr/bin/mkdir -p '/home/bylee/install/pgpool2-4_0_1/bin'
      /bin/sh ../../../libtool   --mode=install /usr/bin/install -c pcp_stop_pgpool pcp_node_count pcp_node_info pcp_proc_count pcp_proc_info pcp_detach_node pcp_attach_node pcp_recovery_node pcp_promote_node pcp_pool_status pcp_watchdog_info '/home/bylee/install/pgpool2-4_0_1/bin'
    libtool: install: /usr/bin/install -c .libs/pcp_stop_pgpool /home/bylee/install/pgpool2-4_0_1/bin/pcp_stop_pgpool
    libtool: install: /usr/bin/install -c .libs/pcp_node_count /home/bylee/install/pgpool2-4_0_1/bin/pcp_node_count
    libtool: install: /usr/bin/install -c .libs/pcp_node_info /home/bylee/install/pgpool2-4_0_1/bin/pcp_node_info
    libtool: install: /usr/bin/install -c .libs/pcp_proc_count /home/bylee/install/pgpool2-4_0_1/bin/pcp_proc_count
    libtool: install: /usr/bin/install -c .libs/pcp_proc_info /home/bylee/install/pgpool2-4_0_1/bin/pcp_proc_info
    libtool: install: /usr/bin/install -c .libs/pcp_detach_node /home/bylee/install/pgpool2-4_0_1/bin/pcp_detach_node
    libtool: install: /usr/bin/install -c .libs/pcp_attach_node /home/bylee/install/pgpool2-4_0_1/bin/pcp_attach_node
    libtool: install: /usr/bin/install -c .libs/pcp_recovery_node /home/bylee/install/pgpool2-4_0_1/bin/pcp_recovery_node
    libtool: install: /usr/bin/install -c .libs/pcp_promote_node /home/bylee/install/pgpool2-4_0_1/bin/pcp_promote_node
    libtool: install: /usr/bin/install -c .libs/pcp_pool_status /home/bylee/install/pgpool2-4_0_1/bin/pcp_pool_status
    libtool: install: /usr/bin/install -c .libs/pcp_watchdog_info /home/bylee/install/pgpool2-4_0_1/bin/pcp_watchdog_info
    make[4]: 'install-data-am'을(를) 위해 할 일이 없습니다.
    make[4]: 디렉터리 '/home/bylee/install/pgpool2-4_0_1/src/tools/pcp' 나감
    make[3]: 디렉터리 '/home/bylee/install/pgpool2-4_0_1/src/tools/pcp' 나감
    Making install in pgmd5
    make[3]: 디렉터리 '/home/bylee/install/pgpool2-4_0_1/src/tools/pgmd5' 들어감
    gcc -DHAVE_CONFIG_H -DDEFAULT_CONFIGDIR=\"/home/bylee/install/pgpool2-4_0_1/etc\" -DPOOL_TOOLS -I. -I../../../src/include  -D_GNU_SOURCE -DPOOL_PRIVATE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o pg_md5.o pg_md5.c
    rm -f md5.c && ln -s ../../../src/auth/md5.c .
    gcc -DHAVE_CONFIG_H -DDEFAULT_CONFIGDIR=\"/home/bylee/install/pgpool2-4_0_1/etc\" -DPOOL_TOOLS -I. -I../../../src/include  -D_GNU_SOURCE -DPOOL_PRIVATE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o md5.o md5.c
    rm -f pool_passwd.c && ln -s ../../../src/auth/pool_passwd.c .
    gcc -DHAVE_CONFIG_H -DDEFAULT_CONFIGDIR=\"/home/bylee/install/pgpool2-4_0_1/etc\" -DPOOL_TOOLS -I. -I../../../src/include  -D_GNU_SOURCE -DPOOL_PRIVATE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o pool_passwd.o pool_passwd.c
    rm -f pool_signal.c && ln -s ../../../src/utils/pool_signal.c .
    gcc -DHAVE_CONFIG_H -DDEFAULT_CONFIGDIR=\"/home/bylee/install/pgpool2-4_0_1/etc\" -DPOOL_TOOLS -I. -I../../../src/include  -D_GNU_SOURCE -DPOOL_PRIVATE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o pool_signal.o pool_signal.c
    rm -f strlcpy.c && ln -s ../../../src/utils/strlcpy.c .
    gcc -DHAVE_CONFIG_H -DDEFAULT_CONFIGDIR=\"/home/bylee/install/pgpool2-4_0_1/etc\" -DPOOL_TOOLS -I. -I../../../src/include  -D_GNU_SOURCE -DPOOL_PRIVATE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o strlcpy.o strlcpy.c
    rm -f regex_array.c && ln -s ../../../src/utils/regex_array.c .
    gcc -DHAVE_CONFIG_H -DDEFAULT_CONFIGDIR=\"/home/bylee/install/pgpool2-4_0_1/etc\" -DPOOL_TOOLS -I. -I../../../src/include  -D_GNU_SOURCE -DPOOL_PRIVATE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o regex_array.o regex_array.c
    rm -f pool_config_variables.c && ln -s ../../../src/config/pool_config_variables.c .
    gcc -DHAVE_CONFIG_H -DDEFAULT_CONFIGDIR=\"/home/bylee/install/pgpool2-4_0_1/etc\" -DPOOL_TOOLS -I. -I../../../src/include  -D_GNU_SOURCE -DPOOL_PRIVATE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o pool_config_variables.o pool_config_variables.c
    gcc -DHAVE_CONFIG_H -DDEFAULT_CONFIGDIR=\"/home/bylee/install/pgpool2-4_0_1/etc\" -DPOOL_TOOLS -I. -I../../../src/include  -D_GNU_SOURCE -DPOOL_PRIVATE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o pool_config.o pool_config.c
    rm -f fe_memutils.c && ln -s ../../../src/tools/fe_memutils.c .
    gcc -DHAVE_CONFIG_H -DDEFAULT_CONFIGDIR=\"/home/bylee/install/pgpool2-4_0_1/etc\" -DPOOL_TOOLS -I. -I../../../src/include  -D_GNU_SOURCE -DPOOL_PRIVATE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o fe_memutils.o fe_memutils.c
    rm -f pool_globals.c && ln -s ../../../src/main/pool_globals.c .
    gcc -DHAVE_CONFIG_H -DDEFAULT_CONFIGDIR=\"/home/bylee/install/pgpool2-4_0_1/etc\" -DPOOL_TOOLS -I. -I../../../src/include  -D_GNU_SOURCE -DPOOL_PRIVATE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o pool_globals.o pool_globals.c
    /bin/sh ../../../libtool  --tag=CC   --mode=link gcc  -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing  -L//usr/lib/jvm/java-1.8.0-openjdk-1.8.0.161-0.b14.fc27.x86_64/jre/lib/amd64/server/ -o pg_md5 pg_md5.o ../fe_port.o md5.o pool_passwd.o pool_signal.o strlcpy.o regex_array.o pool_config_variables.o pool_config.o fe_memutils.o pool_globals.o  -lcrypt -lresolv -lnsl -lm
    libtool: link: gcc -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -o pg_md5 pg_md5.o ../fe_port.o md5.o pool_passwd.o pool_signal.o strlcpy.o regex_array.o pool_config_variables.o pool_config.o fe_memutils.o pool_globals.o  -L//usr/lib/jvm/java-1.8.0-openjdk-1.8.0.161-0.b14.fc27.x86_64/jre/lib/amd64/server/ -lcrypt -lresolv -lnsl -lm
    make[4]: 디렉터리 '/home/bylee/install/pgpool2-4_0_1/src/tools/pgmd5' 들어감
     /usr/bin/mkdir -p '/home/bylee/install/pgpool2-4_0_1/bin'
      /bin/sh ../../../libtool   --mode=install /usr/bin/install -c pg_md5 '/home/bylee/install/pgpool2-4_0_1/bin'
    libtool: install: /usr/bin/install -c pg_md5 /home/bylee/install/pgpool2-4_0_1/bin/pg_md5
    make[4]: 'install-data-am'을(를) 위해 할 일이 없습니다.
    make[4]: 디렉터리 '/home/bylee/install/pgpool2-4_0_1/src/tools/pgmd5' 나감
    make[3]: 디렉터리 '/home/bylee/install/pgpool2-4_0_1/src/tools/pgmd5' 나감
    Making install in pgenc
    make[3]: 디렉터리 '/home/bylee/install/pgpool2-4_0_1/src/tools/pgenc' 들어감
    gcc -DHAVE_CONFIG_H -DDEFAULT_CONFIGDIR=\"/home/bylee/install/pgpool2-4_0_1/etc\" -DPOOL_TOOLS -I. -I../../../src/include  -D_GNU_SOURCE -DPOOL_PRIVATE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o pg_enc.o pg_enc.c
    rm -f ssl_utils.c && ln -s ../../../src/utils/ssl_utils.c .
    gcc -DHAVE_CONFIG_H -DDEFAULT_CONFIGDIR=\"/home/bylee/install/pgpool2-4_0_1/etc\" -DPOOL_TOOLS -I. -I../../../src/include  -D_GNU_SOURCE -DPOOL_PRIVATE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o ssl_utils.o ssl_utils.c
    rm -f md5.c && ln -s ../../../src/auth/md5.c .
    gcc -DHAVE_CONFIG_H -DDEFAULT_CONFIGDIR=\"/home/bylee/install/pgpool2-4_0_1/etc\" -DPOOL_TOOLS -I. -I../../../src/include  -D_GNU_SOURCE -DPOOL_PRIVATE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o md5.o md5.c
    rm -f base64.c && ln -s ../../../src/utils/base64.c .
    gcc -DHAVE_CONFIG_H -DDEFAULT_CONFIGDIR=\"/home/bylee/install/pgpool2-4_0_1/etc\" -DPOOL_TOOLS -I. -I../../../src/include  -D_GNU_SOURCE -DPOOL_PRIVATE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o base64.o base64.c
    rm -f pool_passwd.c && ln -s ../../../src/auth/pool_passwd.c .
    gcc -DHAVE_CONFIG_H -DDEFAULT_CONFIGDIR=\"/home/bylee/install/pgpool2-4_0_1/etc\" -DPOOL_TOOLS -I. -I../../../src/include  -D_GNU_SOURCE -DPOOL_PRIVATE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o pool_passwd.o pool_passwd.c
    rm -f pool_signal.c && ln -s ../../../src/utils/pool_signal.c .
    gcc -DHAVE_CONFIG_H -DDEFAULT_CONFIGDIR=\"/home/bylee/install/pgpool2-4_0_1/etc\" -DPOOL_TOOLS -I. -I../../../src/include  -D_GNU_SOURCE -DPOOL_PRIVATE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o pool_signal.o pool_signal.c
    rm -f strlcpy.c && ln -s ../../../src/utils/strlcpy.c .
    gcc -DHAVE_CONFIG_H -DDEFAULT_CONFIGDIR=\"/home/bylee/install/pgpool2-4_0_1/etc\" -DPOOL_TOOLS -I. -I../../../src/include  -D_GNU_SOURCE -DPOOL_PRIVATE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o strlcpy.o strlcpy.c
    rm -f regex_array.c && ln -s ../../../src/utils/regex_array.c .
    gcc -DHAVE_CONFIG_H -DDEFAULT_CONFIGDIR=\"/home/bylee/install/pgpool2-4_0_1/etc\" -DPOOL_TOOLS -I. -I../../../src/include  -D_GNU_SOURCE -DPOOL_PRIVATE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o regex_array.o regex_array.c
    rm -f pool_config_variables.c && ln -s ../../../src/config/pool_config_variables.c .
    gcc -DHAVE_CONFIG_H -DDEFAULT_CONFIGDIR=\"/home/bylee/install/pgpool2-4_0_1/etc\" -DPOOL_TOOLS -I. -I../../../src/include  -D_GNU_SOURCE -DPOOL_PRIVATE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o pool_config_variables.o pool_config_variables.c
    rm -f pool_config.c && ln -s ../../../src/config/pool_config.c .
    gcc -DHAVE_CONFIG_H -DDEFAULT_CONFIGDIR=\"/home/bylee/install/pgpool2-4_0_1/etc\" -DPOOL_TOOLS -I. -I../../../src/include  -D_GNU_SOURCE -DPOOL_PRIVATE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o pool_config.o pool_config.c
    rm -f fe_memutils.c && ln -s ../../../src/tools/fe_memutils.c .
    gcc -DHAVE_CONFIG_H -DDEFAULT_CONFIGDIR=\"/home/bylee/install/pgpool2-4_0_1/etc\" -DPOOL_TOOLS -I. -I../../../src/include  -D_GNU_SOURCE -DPOOL_PRIVATE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o fe_memutils.o fe_memutils.c
    rm -f pool_path.c && ln -s ../../../src/utils/pool_path.c .
    gcc -DHAVE_CONFIG_H -DDEFAULT_CONFIGDIR=\"/home/bylee/install/pgpool2-4_0_1/etc\" -DPOOL_TOOLS -I. -I../../../src/include  -D_GNU_SOURCE -DPOOL_PRIVATE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o pool_path.o pool_path.c
    rm -f pool_globals.c && ln -s ../../../src/main/pool_globals.c .
    gcc -DHAVE_CONFIG_H -DDEFAULT_CONFIGDIR=\"/home/bylee/install/pgpool2-4_0_1/etc\" -DPOOL_TOOLS -I. -I../../../src/include  -D_GNU_SOURCE -DPOOL_PRIVATE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o pool_globals.o pool_globals.c
    /bin/sh ../../../libtool  --tag=CC   --mode=link gcc  -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing  -L//usr/lib/jvm/java-1.8.0-openjdk-1.8.0.161-0.b14.fc27.x86_64/jre/lib/amd64/server/ -o pg_enc pg_enc.o ../fe_port.o ssl_utils.o md5.o base64.o pool_passwd.o pool_signal.o strlcpy.o regex_array.o pool_config_variables.o pool_config.o fe_memutils.o pool_path.o pool_globals.o  -lcrypt -lresolv -lnsl -lm
    libtool: link: gcc -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -o pg_enc pg_enc.o ../fe_port.o ssl_utils.o md5.o base64.o pool_passwd.o pool_signal.o strlcpy.o regex_array.o pool_config_variables.o pool_config.o fe_memutils.o pool_path.o pool_globals.o  -L//usr/lib/jvm/java-1.8.0-openjdk-1.8.0.161-0.b14.fc27.x86_64/jre/lib/amd64/server/ -lcrypt -lresolv -lnsl -lm
    make[4]: 디렉터리 '/home/bylee/install/pgpool2-4_0_1/src/tools/pgenc' 들어감
     /usr/bin/mkdir -p '/home/bylee/install/pgpool2-4_0_1/bin'
      /bin/sh ../../../libtool   --mode=install /usr/bin/install -c pg_enc '/home/bylee/install/pgpool2-4_0_1/bin'
    libtool: install: /usr/bin/install -c pg_enc /home/bylee/install/pgpool2-4_0_1/bin/pg_enc
    make[4]: 'install-data-am'을(를) 위해 할 일이 없습니다.
    make[4]: 디렉터리 '/home/bylee/install/pgpool2-4_0_1/src/tools/pgenc' 나감
    make[3]: 디렉터리 '/home/bylee/install/pgpool2-4_0_1/src/tools/pgenc' 나감
    Making install in pgproto
    make[3]: 디렉터리 '/home/bylee/install/pgpool2-4_0_1/src/tools/pgproto' 들어감
    gcc -DHAVE_CONFIG_H -I. -I../../../src/include  -D_GNU_SOURCE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o main.o main.c
    gcc -DHAVE_CONFIG_H -I. -I../../../src/include  -D_GNU_SOURCE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o read.o read.c
    read.c:257:1: warning: 'read_int16' defined but not used [-Wunused-function]
     read_int16(PGconn *conn)
     ^~~~~~~~~~
    gcc -DHAVE_CONFIG_H -I. -I../../../src/include  -D_GNU_SOURCE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o send.o send.c
    send.c: In function 'send_char':
    send.c:37:8: warning: variable 'status' set but not used [-Wunused-but-set-variable]
      int   status;
            ^~~~~~
    send.c: In function 'send_int':
    send.c:48:8: warning: variable 'status' set but not used [-Wunused-but-set-variable]
      int   status;
            ^~~~~~
    send.c: In function 'send_int16':
    send.c:60:8: warning: variable 'status' set but not used [-Wunused-but-set-variable]
      int   status;
            ^~~~~~
    send.c: In function 'send_string':
    send.c:72:8: warning: variable 'status' set but not used [-Wunused-but-set-variable]
      int   status;
            ^~~~~~
    send.c: In function 'send_byte':
    send.c:83:8: warning: variable 'status' set but not used [-Wunused-but-set-variable]
      int   status;
            ^~~~~~
    gcc -DHAVE_CONFIG_H -I. -I../../../src/include  -D_GNU_SOURCE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o extended_query.o extended_query.c
    gcc -DHAVE_CONFIG_H -I. -I../../../src/include  -D_GNU_SOURCE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o buffer.o buffer.c
    gcc -DHAVE_CONFIG_H -I. -I../../../src/include  -D_GNU_SOURCE -I /home/bylee/install/agensgraph/include   -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -c -o fe_memutils.o fe_memutils.c
    /bin/sh ../../../libtool  --tag=CC   --mode=link gcc  -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing  -L//usr/lib/jvm/java-1.8.0-openjdk-1.8.0.161-0.b14.fc27.x86_64/jre/lib/amd64/server/ -o pgproto main.o read.o send.o extended_query.o buffer.o fe_memutils.o -L/home/bylee/install/agensgraph/lib -lpq -lcrypt -lresolv -lnsl -lm
    libtool: link: gcc -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fno-strict-aliasing -o pgproto main.o read.o send.o extended_query.o buffer.o fe_memutils.o  -L//usr/lib/jvm/java-1.8.0-openjdk-1.8.0.161-0.b14.fc27.x86_64/jre/lib/amd64/server/ -L/home/bylee/install/agensgraph/lib -lpq -lcrypt -lresolv -lnsl -lm
    make[4]: 디렉터리 '/home/bylee/install/pgpool2-4_0_1/src/tools/pgproto' 들어감
     /usr/bin/mkdir -p '/home/bylee/install/pgpool2-4_0_1/bin'
      /bin/sh ../../../libtool   --mode=install /usr/bin/install -c pgproto '/home/bylee/install/pgpool2-4_0_1/bin'
    libtool: install: /usr/bin/install -c pgproto /home/bylee/install/pgpool2-4_0_1/bin/pgproto
    make[4]: 'install-data-am'을(를) 위해 할 일이 없습니다.
    make[4]: 디렉터리 '/home/bylee/install/pgpool2-4_0_1/src/tools/pgproto' 나감
    make[3]: 디렉터리 '/home/bylee/install/pgpool2-4_0_1/src/tools/pgproto' 나감
    make[3]: 디렉터리 '/home/bylee/install/pgpool2-4_0_1/src/tools' 들어감
    ln -s ../test/pgpool_setup .
    ln -s ../test/watchdog_setup .
    make[4]: 디렉터리 '/home/bylee/install/pgpool2-4_0_1/src/tools' 들어감
     /usr/bin/mkdir -p '/home/bylee/install/pgpool2-4_0_1/bin'
     /usr/bin/install -c pgpool_setup watchdog_setup '/home/bylee/install/pgpool2-4_0_1/bin'
    make[4]: 'install-data-am'을(를) 위해 할 일이 없습니다.
    make[4]: 디렉터리 '/home/bylee/install/pgpool2-4_0_1/src/tools' 나감
    make[3]: 디렉터리 '/home/bylee/install/pgpool2-4_0_1/src/tools' 나감
    make[2]: 디렉터리 '/home/bylee/install/pgpool2-4_0_1/src/tools' 나감
    Making install in include
    make[2]: 디렉터리 '/home/bylee/install/pgpool2-4_0_1/src/include' 들어감
    make[3]: 디렉터리 '/home/bylee/install/pgpool2-4_0_1/src/include' 들어감
    make[3]: 'install-exec-am'을(를) 위해 할 일이 없습니다.
    make[3]: 'install-data-am'을(를) 위해 할 일이 없습니다.
    make[3]: 디렉터리 '/home/bylee/install/pgpool2-4_0_1/src/include' 나감
    make[2]: 디렉터리 '/home/bylee/install/pgpool2-4_0_1/src/include' 나감
    make[1]: 디렉터리 '/home/bylee/install/pgpool2-4_0_1/src' 나감
    make[1]: 디렉터리 '/home/bylee/install/pgpool2-4_0_1' 들어감
    make[2]: 디렉터리 '/home/bylee/install/pgpool2-4_0_1' 들어감
    make[2]: 'install-exec-am'을(를) 위해 할 일이 없습니다.
    make[2]: 'install-data-am'을(를) 위해 할 일이 없습니다.
    make[2]: 디렉터리 '/home/bylee/install/pgpool2-4_0_1' 나감
    make[1]: 디렉터리 '/home/bylee/install/pgpool2-4_0_1' 나감
     
    [bylee@bylee5 pgpool2-4_0_1]$ ll
    합계 2220
    -rw-rw-r--.  1 bylee bylee    123 10월 31 11:11 AUTHORS
    -rw-rw-r--.  1 bylee bylee    666 10월 31 11:11 COPYING
    -rw-rw-r--.  1 bylee bylee     10 10월 31 11:11 ChangeLog
    -rw-rw-r--.  1 bylee bylee  15744 10월 31 11:11 INSTALL
    -rw-rw-r--.  1 bylee bylee  25274 11월  6 14:12 Makefile
    -rw-rw-r--.  1 bylee bylee    249 10월 31 11:11 Makefile.am
    -rw-rw-r--.  1 bylee bylee  25281 10월 31 11:11 Makefile.in
    -rw-rw-r--.  1 bylee bylee 441205 10월 31 11:11 NEWS
    -rw-rw-r--.  1 bylee bylee     32 10월 31 11:11 README
    -rw-rw-r--.  1 bylee bylee   1261 10월 31 11:11 README.build
    -rw-rw-r--.  1 bylee bylee     36 10월 31 11:11 README.euc_jp
    -rw-rw-r--.  1 bylee bylee   2156 10월 31 11:11 README.online-recovery
    -rw-rw-r--.  1 bylee bylee   2381 10월 31 11:11 TODO
    -rw-rw-r--.  1 bylee bylee   3641 10월 31 11:11 ac_func_accept_argtypes.m4
    -rw-rw-r--.  1 bylee bylee  30871 10월 31 11:11 aclocal.m4
    drwxrwxr-x.  2 bylee bylee   4096 11월  6 14:12 bin
    -rw-rw-r--.  1 bylee bylee   4351 10월 31 11:11 c-compiler.m4
    -rw-rw-r--.  1 bylee bylee  10772 10월 31 11:11 c-library.m4
    -rw-rw-r--.  1 bylee bylee      0 10월 31 11:11 compile
    -rwxrwxr-x.  1 bylee bylee  44826 10월 31 11:11 config.guess
    -rw-rw-r--.  1 bylee bylee 310183 11월  6 14:12 config.log
    -rwxrwxr-x.  1 bylee bylee  62721 11월  6 14:12 config.status
    -rwxrwxr-x.  1 bylee bylee  35454 10월 31 11:11 config.sub
    -rwxrwxr-x.  1 bylee bylee 497862 10월 31 11:11 configure
    -rw-rw-r--.  1 bylee bylee  15465 10월 31 11:11 configure.ac
    -rwxrwxr-x.  1 bylee bylee  20334 10월 31 11:11 depcomp
    drwxrwxr-x.  3 bylee bylee   4096 11월  6 14:12 doc
    drwxrwxr-x.  3 bylee bylee   4096 11월  6 14:12 doc.ja
    drwxrwxr-x.  2 bylee bylee   4096 11월  6 14:12 etc
    -rw-rw-r--.  1 bylee bylee   5960 10월 31 11:11 general.m4
    drwxrwxr-x.  2 bylee bylee   4096 11월  6 14:12 include
    -rwxrwxr-x.  1 bylee bylee  13998 10월 31 11:11 install-sh
    drwxrwxr-x.  2 bylee bylee   4096 11월  6 14:12 lib
    -rwxrwxr-x.  1 bylee bylee 293285 11월  6 14:12 libtool
    -rwxrwxr-x.  1 bylee bylee 283680 10월 31 11:11 ltmain.sh
    drwxrwxr-x.  2 bylee bylee   4096 10월 31 11:11 m4
    -rwxrwxr-x.  1 bylee bylee  10346 10월 31 11:11 missing
    -rwxrwxr-x.  1 bylee bylee   3538 10월 31 11:11 mkinstalldirs
    drwxrwxr-x.  3 bylee bylee   4096 11월  6 14:12 share
    drwxrwxr-x. 22 bylee bylee   4096 11월  6 14:12 src
    -rwxrwxr-x.  1 bylee bylee   6383 10월 31 11:11 ylwrap
     
    5. pgpool-recover
    [bylee@bylee5 pgpool2-4_0_1]$ cd src/sql/pgpool-recovery/
    [bylee@bylee5 pgpool-recovery]$ make
    sed 's,MODULE_PATHNAME,$libdir/pgpool-recovery,g' pgpool-recovery.sql.in >pgpool-recovery.sql
    gcc -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -O2 -fPIC -I. -I./ -I/home/bylee/install/agensgraph/include/postgresql/server -I/home/bylee/install/agensgraph/include/postgresql/internal  -D_GNU_SOURCE   -c -o pgpool-recovery.o pgpool-recovery.c
    gcc -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -O2 -fPIC -L/home/bylee/install/agensgraph/lib -L//usr/lib/jvm/java-1.8.0-openjdk-1.8.0.161-0.b14.fc27.x86_64/jre/lib/amd64/server/  -Wl,--as-needed -Wl,-rpath,'/home/bylee/install/agensgraph/lib',--enable-new-dtags  -shared -o pgpool-recovery.so pgpool-recovery.o
    [bylee@bylee5 pgpool-recovery]$ make install
    /usr/bin/mkdir -p '/home/bylee/install/agensgraph/share/postgresql/extension'
    /usr/bin/mkdir -p '/home/bylee/install/agensgraph/share/postgresql/extension'
    /usr/bin/mkdir -p '/home/bylee/install/agensgraph/lib/postgresql'
    /usr/bin/install -c -m 644 .//pgpool_recovery.control '/home/bylee/install/agensgraph/share/postgresql/extension/'
    /usr/bin/install -c -m 644 .//pgpool_recovery--1.1.sql .//pgpool_recovery--1.2.sql .//pgpool_recovery--1.1--1.2.sql pgpool-recovery.sql '/home/bylee/install/agensgraph/share/postgresql/extension/'
    /usr/bin/install -c -m 755  pgpool-recovery.so '/home/bylee/install/agensgraph/lib/postgresql/'
     
    [bylee@bylee5 pgpool-recovery]$ agens -d template1
    agens (AgensGraph 1.4devel, based on PostgreSQL 10.3)
    Type "help" for help.
     
    template1=# create extension pgpool_recovery;
    CREATE EXTENSION
    template1=#
     
    6. postgresql.conf 설정
    $ vi /home/bylee/install/agensgraph/data/postgresql.conf
    pgpool.pg_ctl = '/home/bylee/install/agensgraph/bin/agens'
     
     
    [bylee@bylee5 data]$ ag_ctl reload -D /home/bylee/install/agensgraph/data
    server signaled
     
     
    7. pgpool.conf 생성
    [bylee@bylee5 pgpool2-4_0_1]$ cp etc/pgpool.conf.sample pgpool.conf
    $ vi pgpool.conf
    backend_data_directory0 = '/home/bylee/install/agensgraph/data'
    num_init_children = 80
    connection_life_time = 10
    client_idle_limit = 10
    pid_file_name = '/home/bylee/install/pgpool2-4_0_1/pgpool.pid'
    logdir = '/home/bylee/install/pgpool2-4_0_1/'
     
    8. pgpool 시작
    [bylee@bylee5 pgpool2-4_0_1]$ bin/pgpool -f pgpool.conf
    [bylee@bylee5 pgpool2-4_0_1]$ ps -ef | grep pgpool
    bylee    23874  7410  0 15:12 ?        00:00:00 bin/pgpool -f pgpool.conf
    bylee    23885 23874  0 15:12 ?        00:00:00 pgpool: wait for connection request
    bylee    23886 23874  0 15:12 ?        00:00:00 pgpool: wait for connection request
    bylee    23887 23874  0 15:12 ?        00:00:00 pgpool: wait for connection request
    bylee    23888 23874  0 15:12 ?        00:00:00 pgpool: wait for connection request
    bylee    23890 23874  0 15:12 ?        00:00:00 pgpool: wait for connection request
    bylee    23891 23874  0 15:12 ?        00:00:00 pgpool: wait for connection request
    bylee    23892 23874  0 15:12 ?        00:00:00 pgpool: wait for connection request
    bylee    23894 23874  0 15:12 ?        00:00:00 pgpool: wait for connection request
    bylee    23895 23874  0 15:12 ?        00:00:00 pgpool: wait for connection request
    bylee    23896 23874  0 15:12 ?        00:00:00 pgpool: wait for connection request
    bylee    23897 23874  0 15:12 ?        00:00:00 pgpool: wait for connection request
    bylee    23898 23874  0 15:12 ?        00:00:00 pgpool: wait for connection request
    bylee    23899 23874  0 15:12 ?        00:00:00 pgpool: wait for connection request
    bylee    23900 23874  0 15:12 ?        00:00:00 pgpool: wait for connection request
    bylee    23901 23874  0 15:12 ?        00:00:00 pgpool: wait for connection request
    bylee    23902 23874  0 15:12 ?        00:00:00 pgpool: wait for connection request
    bylee    23903 23874  0 15:12 ?        00:00:00 pgpool: wait for connection request
    bylee    23904 23874  0 15:12 ?        00:00:00 pgpool: wait for connection request
    bylee    23905 23874  0 15:12 ?        00:00:00 pgpool: wait for connection request
    bylee    23906 23874  0 15:12 ?        00:00:00 pgpool: wait for connection request
    bylee    23907 23874  0 15:12 ?        00:00:00 pgpool: wait for connection request
    bylee    23908 23874  0 15:12 ?        00:00:00 pgpool: wait for connection request
    bylee    23909 23874  0 15:12 ?        00:00:00 pgpool: wait for connection request
    bylee    23910 23874  0 15:12 ?        00:00:00 pgpool: wait for connection request
    bylee    23911 23874  0 15:12 ?        00:00:00 pgpool: wait for connection request
    bylee    23912 23874  0 15:12 ?        00:00:00 pgpool: wait for connection request
    bylee    23913 23874  0 15:12 ?        00:00:00 pgpool: wait for connection request
    bylee    23914 23874  0 15:12 ?        00:00:00 pgpool: wait for connection request
    bylee    23915 23874  0 15:12 ?        00:00:00 pgpool: wait for connection request
    bylee    23916 23874  0 15:12 ?        00:00:00 pgpool: wait for connection request
    bylee    23918 23874  0 15:12 ?        00:00:00 pgpool: wait for connection request
    bylee    23919 23874  0 15:12 ?        00:00:00 pgpool: wait for connection request
    bylee    23920 23874  0 15:12 ?        00:00:00 pgpool: PCP: wait for connection request
    bylee    23921 23874  0 15:12 ?        00:00:00 pgpool: worker process
    bylee    23922 23874  0 15:12 ?        00:00:00 pgpool: health check process(0)
    bylee    24104 25943  0 15:12 pts/0    00:00:00 grep --color=auto pgpool
    [bylee@bylee5 pgpool2-4_0_1]$
    [bylee@bylee5 pgpool2-4_0_1]$
     
    9. pgpool 접속
    [bylee@bylee5 pgpool2-4_0_1]$ netstat -nlp | grep :9999
    (Not all processes could be identified, non-owned process info
     will not be shown, you would have to be root to see it all.)
    tcp        0      0 127.0.0.1:9999          0.0.0.0:*               LISTEN      23874/bin/pgpool   
    tcp6       0      0 ::1:9999                :::*                    LISTEN      23874/bin/pgpool   
    [bylee@bylee5 pgpool2-4_0_1]$ agens -p 9999
    agens (AgensGraph 1.4devel, based on PostgreSQL 10.3)
    Type "help" for help.
     
    bylee=# show pool_nodes;
     node_id | hostname  | port | status | lb_weight |  role  | select_cnt | load_balance_node | replication_delay | last_status_change 
    ---------+-----------+------+--------+-----------+--------+------------+-------------------+-------------------+---------------------
     0       | localhost | 5432 | up     | 1.000000  | master | 0          | true              | 0                 | 2018-11-06 15:12:00
    (1 row)
     
    bylee=# create graph pgpool_test
    bylee-# ;
    CREATE GRAPH
    bylee=# show graph_path;
     graph_path
    ------------
     bylee
    (1 row)
     
    bylee=# set graph_path to pgpool_test;
    SET
    bylee=# create vlabel pgpool_v;
    CREATE VLABEL
    bylee=# create (:pgpool_v{id:1});
    GRAPH WRITE (INSERT VERTEX 1, INSERT EDGE 0)
    bylee=# match (n) return n;
               n           
    ------------------------
     pgpool_v[3.1]{"id": 1}
    (1 row)
     
    bylee=#
     
    11. 10 클라이언트 테스트
    [bylee@bylee5 pgpool2-4_0_1]$ pgbench -c 10 -C -T 60 pgbouncer_bench
    starting vacuum...end.
    transaction type: <builtin: TPC-B (sort of)>
    scaling factor: 10
    query mode: simple
    number of clients: 10
    number of threads: 1
    duration: 60 s
    number of transactions actually processed: 24644
    latency average = 24.352 ms
    tps = 410.646910 (including connections establishing)
    tps = 445.915351 (excluding connections establishing)
    [bylee@bylee5 pgpool2-4_0_1]$ pgbench -c 10 -C -T 60 -p 9999 pgbouncer_bench
    starting vacuum...end.
    transaction type: <builtin: TPC-B (sort of)>
    scaling factor: 10
    query mode: simple
    number of clients: 10
    number of threads: 1
    duration: 60 s
    number of transactions actually processed: 46588
    latency average = 12.881 ms
    tps = 776.353860 (including connections establishing)
    tps = 817.613061 (excluding connections establishing)
     
    12. 80 클라이언트 테스트
    [bylee@bylee5 pgpool2-4_0_1]$ pgbench -c 80 -C -T 60 pgbouncer_bench
    starting vacuum...end.
    transaction type: <builtin: TPC-B (sort of)>
    scaling factor: 10
    query mode: simple
    number of clients: 80
    number of threads: 1
    duration: 60 s
    number of transactions actually processed: 32627
    latency average = 147.321 ms
    tps = 543.031183 (including connections establishing)
    tps = 549.262524 (excluding connections establishing)
    [bylee@bylee5 pgpool2-4_0_1]$ pgbench -c 80 -C -T 60 -p 9999 pgbouncer_bench
    starting vacuum...end.
    transaction type: <builtin: TPC-B (sort of)>
    scaling factor: 10
    query mode: simple
    number of clients: 80
    number of threads: 1
    duration: 60 s
    number of transactions actually processed: 50073
    latency average = 95.967 ms
    tps = 833.619365 (including connections establishing)
    tps = 839.282082 (excluding connections establishing)
    [bylee@bylee5 pgpool2-4_0_1]$
     
     
    13. pgpool 종료
    [bylee@bylee5 pgpool2-4_0_1]$ bin/pgpool -f pgpool.conf stop

    'PostgreSQL' 카테고리의 다른 글

    pgBouncer와 pgPool-II 성능 측정  (0) 2019.10.11
    pgBouncer 소스 수정량 확인  (0) 2019.10.11
    pgBouncer 설치  (0) 2019.10.11
    PostgreSQL 백업 도구 비교  (0) 2019.10.11
    WAL-E 설치  (0) 2019.10.11
Designed by Tistory.