installation issues linux

charan4599 commented 6 years ago

hi I am trying to install pgqaurrel in linux machine and get i below error during make statement i downloaded the latest version of pgqaurrel. Can you please check it ? $ make Scanning dependencies of target mini [ 3%] Building C object mini/CMakeFiles/mini.dir/mini-file.c.o [ 6%] Building C object mini/CMakeFiles/mini.dir/mini-parser.c.o [ 9%] Building C object mini/CMakeFiles/mini.dir/mini-readline.c.o [ 12%] Building C object mini/CMakeFiles/mini.dir/mini-strip.c.o Linking C shared library libmini.so [ 12%] Built target mini Scanning dependencies of target pgquarrel [ 16%] Building C object CMakeFiles/pgquarrel.dir/src/aggregate.c.o [ 19%] Building C object CMakeFiles/pgquarrel.dir/src/cast.c.o [ 22%] Building C object CMakeFiles/pgquarrel.dir/src/collation.c.o [ 25%] Building C object CMakeFiles/pgquarrel.dir/src/common.c.o /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/src/common.c:97: error: conflicting types for ‘ScanKeywordLookup’ /usr/include/pgsql/server/parser/keywords.h:34: note: previous declaration of ‘ScanKeywordLookup’ was here make[2]: [CMakeFiles/pgquarrel.dir/src/common.c.o] Error 1 make[1]: [CMakeFiles/pgquarrel.dir/all] Error 2 make: *** [all] Error 2

Charan

eulerto commented 6 years ago

@charan4599 It seems you are using version < 9.6. What is your exact Postgres version? What is your OS? Also, do you have more than one PostgreSQL version installed in this OS? Could you show the cmake output? I'm also interested in the make VERBOSE=1 output. In my test machine, pgquarrel builds on all postgres versions from 9.1.

charan4599 commented 6 years ago

@eulerto Here is the output you requested

[postgres@VITECH-DB-PGGOLDQA pgquarrel-pgquarrel_0_4_0]$ cmake . -- The C compiler identification is GNU 4.4.7 -- Check for working C compiler: /usr/bin/cc -- Check for working C compiler: /usr/bin/cc -- works -- Detecting C compiler ABI info -- Detecting C compiler ABI info - done -- Found PostgreSQL: /u01/PostgreSQL/9.6/lib (found version "9.6.6") -- PostgreSQL include dirs: /u01/PostgreSQL/9.6/include;/usr/include/pgsql/server -- PostgreSQL library dirs: /u01/PostgreSQL/9.6/lib -- PostgreSQL libraries: pq -- Configuring done -- Generating done -- Build files have been written to: /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0 [postgres@VITECH-DB-PGGOLDQA pgquarrel-pgquarrel_0_4_0]$ make Scanning dependencies of target mini [ 3%] Building C object mini/CMakeFiles/mini.dir/mini-file.c.o [ 6%] Building C object mini/CMakeFiles/mini.dir/mini-parser.c.o [ 9%] Building C object mini/CMakeFiles/mini.dir/mini-readline.c.o [ 12%] Building C object mini/CMakeFiles/mini.dir/mini-strip.c.o Linking C shared library libmini.so [ 12%] Built target mini Scanning dependencies of target pgquarrel [ 16%] Building C object CMakeFiles/pgquarrel.dir/src/aggregate.c.o [ 19%] Building C object CMakeFiles/pgquarrel.dir/src/cast.c.o [ 22%] Building C object CMakeFiles/pgquarrel.dir/src/collation.c.o [ 25%] Building C object CMakeFiles/pgquarrel.dir/src/common.c.o /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/src/common.c:97: error: conflicting types for ‘ScanKeywordLookup’ /usr/include/pgsql/server/parser/keywords.h:34: note: previous declaration of ‘ScanKeywordLookup’ was here make[2]: [CMakeFiles/pgquarrel.dir/src/common.c.o] Error 1 make[1]: [CMakeFiles/pgquarrel.dir/all] Error 2 make: *** [all] Error 2

charan4599 commented 6 years ago

@eulerto postgres and os version:

[postgres@VITECH-DB-PGGOLDQA pgquarrel-pgquarrel_0_4_0]$ psql psql.bin (9.6.6) Type "help" for help.

postgres=# select version(); version

PostgreSQL 9.6.6 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-16), 64-bit (1 row)

postgres=# \q [postgres@VITECH-DB-PGGOLDQA pgquarrel-pgquarrel_0_4_0]$ cat /etc/redhat-release Red Hat Enterprise Linux Server release 6.5 (Santiago)

charan4599 commented 6 years ago

@eulerto Make verbose output:

[postgres@VITECH-DB-PGGOLDQA pgquarrel-pgquarrel_0_4_0]$ make VERBOSE=1 /usr/bin/cmake -H/home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0 -B/home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0 --check-build-system CMakeFiles/Makefile.cmake 0 /usr/bin/cmake -E cmake_progress_start /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/CMakeFiles /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/CMakeFiles/progress.marks make -f CMakeFiles/Makefile2 all make[1]: Entering directory /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0' make -f mini/CMakeFiles/mini.dir/build.make mini/CMakeFiles/mini.dir/depend make[2]: Entering directory/home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0' cd /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0 && /usr/bin/cmake -E cmake_depends "Unix Makefiles" /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0 /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/mini /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0 /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/mini /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/mini/CMakeFiles/mini.dir/DependInfo.cmake --color= make[2]: Leaving directory /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0' make -f mini/CMakeFiles/mini.dir/build.make mini/CMakeFiles/mini.dir/build make[2]: Entering directory/home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0' make[2]: Nothing to be done for mini/CMakeFiles/mini.dir/build'. make[2]: Leaving directory/home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0' /usr/bin/cmake -E cmake_progress_report /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/CMakeFiles 1 2 3 4 [ 12%] Built target mini make -f CMakeFiles/pgquarrel.dir/build.make CMakeFiles/pgquarrel.dir/depend make[2]: Entering directory /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0' cd /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0 && /usr/bin/cmake -E cmake_depends "Unix Makefiles" /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0 /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0 /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0 /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0 /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/CMakeFiles/pgquarrel.dir/DependInfo.cmake --color= make[2]: Leaving directory/home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0' make -f CMakeFiles/pgquarrel.dir/build.make CMakeFiles/pgquarrel.dir/build make[2]: Entering directory /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0' /usr/bin/cmake -E cmake_progress_report /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/CMakeFiles 8 [ 16%] Building C object CMakeFiles/pgquarrel.dir/src/common.c.o /usr/bin/cc -O0 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing -fwrapv -g -I/u01/PostgreSQL/9.6/include -I/usr/include/pgsql/server -I/home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/mini -o CMakeFiles/pgquarrel.dir/src/common.c.o -c /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/src/common.c /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/src/common.c:97: error: conflicting types for ‘ScanKeywordLookup’ /usr/include/pgsql/server/parser/keywords.h:34: note: previous declaration of ‘ScanKeywordLookup’ was here make[2]: *** [CMakeFiles/pgquarrel.dir/src/common.c.o] Error 1 make[2]: Leaving directory/home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0' make[1]: [CMakeFiles/pgquarrel.dir/all] Error 2 make[1]: Leaving directory `/home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0' make: [all] Error 2

eulerto commented 6 years ago

-- PostgreSQL include dirs: /u01/PostgreSQL/9.6/include;/usr/include/pgsql/server

Per output error, parser/keywords.h is used only in versions < 9.6 but it is trying to include it here. I suspect that cmake is also including -I/usr/include/pgsql/server but it should not (because it is from an old postgres version?). Could you try:

cmake -DCMAKE_INSTALL_PREFIX=/tmp/foo -DCMAKE_PREFIX_PATH=/u01/PostgreSQL/9.6 .

charan4599 commented 6 years ago

@eulerto Did as suggested, and reran make command. Still see same error

[postgres@VITECH-DB-PGGOLDQA pgquarrel-pgquarrel_0_4_0]$ cmake -DCMAKE_INSTALL_PREFIX=/tmp/foo -DCMAKE_PREFIX_PATH=/u01/PostgreSQL/9.6 -- PostgreSQL include dirs: /u01/PostgreSQL/9.6/include;/usr/include/pgsql/server -- PostgreSQL library dirs: /u01/PostgreSQL/9.6/lib -- PostgreSQL libraries: pq -- Configuring done -- Generating done -- Build files have been written to: /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0 [postgres@VITECH-DB-PGGOLDQA pgquarrel-pgquarrel_0_4_0]$ [postgres@VITECH-DB-PGGOLDQA pgquarrel-pgquarrel_0_4_0]$ [postgres@VITECH-DB-PGGOLDQA pgquarrel-pgquarrel_0_4_0]$ [postgres@VITECH-DB-PGGOLDQA pgquarrel-pgquarrel_0_4_0]$ make [ 12%] Built target mini [ 16%] Building C object CMakeFiles/pgquarrel.dir/src/common.c.o /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/src/common.c:97: error: conflicting types for ‘ScanKeywordLookup’ /usr/include/pgsql/server/parser/keywords.h:34: note: previous declaration of ‘ScanKeywordLookup’ was here make[2]: [CMakeFiles/pgquarrel.dir/src/common.c.o] Error 1 make[1]: [CMakeFiles/pgquarrel.dir/all] Error 2 make: *** [all] Error 2

eulerto commented 6 years ago

What is your cmake version? It is still including /usr/include/pgsql/server. Do you have an old postgres version installed?

rpm -qa postgresql*

Clean the tree before trying again.

rm -rf CMakeFiles/ CMakeCache.txt cmake_install.cmake Makefile mini/CMakeFiles/ mini/cmake_install.cmake mini/Makefile

charan4599 commented 6 years ago

@eulerto i did as you suggested and get different error now We had only version of postgres 9.6.3 which we upgraded to 9.6.6

[postgres@VITECH-DB-PGGOLDQA pgquarrel-pgquarrel_0_4_0]$ rpm -qa postgresql* postgresql-8.4.20-8.el6_9.x86_64 postgresql-devel-8.4.20-8.el6_9.x86_64 postgresql-libs-8.4.20-8.el6_9.x86_64 [postgres@VITECH-DB-PGGOLDQA pgquarrel-pgquarrel_0_4_0]$ psql psql.bin (9.6.6) Type "help" for help.

postgres=# \q [postgres@VITECH-DB-PGGOLDQA pgquarrel-pgquarrel_0_4_0]$ ls -lrt total 80 drwxrwxr-x. 3 postgres postgres 4096 Jul 1 11:16 test drwxrwxr-x. 2 postgres postgres 4096 Jul 1 11:16 src -rw-rw-r--. 1 postgres postgres 10969 Jul 1 11:16 README.md -rw-rw-r--. 1 postgres postgres 1517 Jul 1 11:16 LICENSE -rw-rw-r--. 1 postgres postgres 3961 Jul 1 11:16 CMakeLists.txt -rw-rw-r--. 1 postgres postgres 11896 Jul 16 15:41 CMakeCache.txt -rw-rw-r--. 1 postgres postgres 2862 Jul 16 15:41 cmake_install.cmake -rw-rw-r--. 1 postgres postgres 27116 Jul 16 15:42 Makefile drwxrwxr-x. 3 postgres postgres 4096 Jul 16 15:42 mini drwxrwxr-x. 7 postgres postgres 4096 Jul 16 15:42 CMakeFiles [postgres@VITECH-DB-PGGOLDQA pgquarrel-pgquarrel_0_4_0]$ rm -rf CMakeFiles/ CMakeCache.txt cmake_install.cmake Makefile mini/CMakeFiles/ mini/cmake_install.cmake mini/Makefile [postgres@VITECH-DB-PGGOLDQA pgquarrel-pgquarrel_0_4_0]$ [postgres@VITECH-DB-PGGOLDQA pgquarrel-pgquarrel_0_4_0]$ cmake -DCMAKE_INSTALL_PREFIX=/tmp/foo -DCMAKE_PREFIX_PATH=/u01/PostgreSQL/9.6 -- The C compiler identification is GNU 4.4.7 -- Check for working C compiler: /usr/bin/cc -- Check for working C compiler: /usr/bin/cc -- works -- Detecting C compiler ABI info -- Detecting C compiler ABI info - done -- Found PostgreSQL: /u01/PostgreSQL/9.6/lib (found version "9.6.6") -- PostgreSQL include dirs: /u01/PostgreSQL/9.6/include;/u01/PostgreSQL/9.6/include/postgresql/server -- PostgreSQL library dirs: /u01/PostgreSQL/9.6/lib -- PostgreSQL libraries: pq -- Configuring done -- Generating done -- Build files have been written to: /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0 [postgres@VITECH-DB-PGGOLDQA pgquarrel-pgquarrel_0_4_0]$ make Scanning dependencies of target mini [ 3%] Building C object mini/CMakeFiles/mini.dir/mini-file.c.o [ 6%] Building C object mini/CMakeFiles/mini.dir/mini-parser.c.o [ 9%] Building C object mini/CMakeFiles/mini.dir/mini-readline.c.o [ 12%] Building C object mini/CMakeFiles/mini.dir/mini-strip.c.o Linking C shared library libmini.so [ 12%] Built target mini Scanning dependencies of target pgquarrel [ 16%] Building C object CMakeFiles/pgquarrel.dir/src/aggregate.c.o [ 19%] Building C object CMakeFiles/pgquarrel.dir/src/cast.c.o [ 22%] Building C object CMakeFiles/pgquarrel.dir/src/collation.c.o [ 25%] Building C object CMakeFiles/pgquarrel.dir/src/common.c.o [ 29%] Building C object CMakeFiles/pgquarrel.dir/src/conversion.c.o [ 32%] Building C object CMakeFiles/pgquarrel.dir/src/domain.c.o [ 35%] Building C object CMakeFiles/pgquarrel.dir/src/eventtrigger.c.o [ 38%] Building C object CMakeFiles/pgquarrel.dir/src/extension.c.o [ 41%] Building C object CMakeFiles/pgquarrel.dir/src/fdw.c.o [ 45%] Building C object CMakeFiles/pgquarrel.dir/src/function.c.o [ 48%] Building C object CMakeFiles/pgquarrel.dir/src/index.c.o [ 51%] Building C object CMakeFiles/pgquarrel.dir/src/language.c.o [ 54%] Building C object CMakeFiles/pgquarrel.dir/src/matview.c.o [ 58%] Building C object CMakeFiles/pgquarrel.dir/src/operator.c.o [ 61%] Building C object CMakeFiles/pgquarrel.dir/src/privileges.c.o [ 64%] Building C object CMakeFiles/pgquarrel.dir/src/quarrel.c.o [ 67%] Building C object CMakeFiles/pgquarrel.dir/src/rule.c.o [ 70%] Building C object CMakeFiles/pgquarrel.dir/src/schema.c.o [ 74%] Building C object CMakeFiles/pgquarrel.dir/src/sequence.c.o [ 77%] Building C object CMakeFiles/pgquarrel.dir/src/server.c.o [ 80%] Building C object CMakeFiles/pgquarrel.dir/src/statistics.c.o [ 83%] Building C object CMakeFiles/pgquarrel.dir/src/table.c.o [ 87%] Building C object CMakeFiles/pgquarrel.dir/src/textsearch.c.o [ 90%] Building C object CMakeFiles/pgquarrel.dir/src/trigger.c.o [ 93%] Building C object CMakeFiles/pgquarrel.dir/src/type.c.o [ 96%] Building C object CMakeFiles/pgquarrel.dir/src/usermapping.c.o [100%] Building C object CMakeFiles/pgquarrel.dir/src/view.c.o Linking C executable pgquarrel CMakeFiles/pgquarrel.dir/src/quarrel.c.o: In function connectDatabase': /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/src/quarrel.c:666: undefined reference toPQconnectdbParams' collect2: ld returned 1 exit status make[2]: [pgquarrel] Error 1 make[1]: [CMakeFiles/pgquarrel.dir/all] Error 2 make: *** [all] Error 2

charan4599 commented 6 years ago

@eulerto cmake version

[postgres@VITECH-DB-PGGOLDQA pgquarrel-pgquarrel_0_4_0]$ cmake --version cmake version 2.8.12.2

eulerto commented 6 years ago

Linking C executable pgquarrel CMakeFiles/pgquarrel.dir/src/quarrel.c.o: In function connectDatabase': /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/src/quarrel.c:666: undefined reference toPQconnectdbParams'

It seems it is trying to link to some old library (8.4). Could you show make VERBOSE=1?

charan4599 commented 6 years ago

[postgres@VITECH-DB-PGGOLDQA pgquarrel-pgquarrel_0_4_0]$ make VERBOSE=1 /usr/bin/cmake -H/home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0 -B/home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0 --check-build-system CMakeFiles/Makefile.cmake 0 /usr/bin/cmake -E cmake_progress_start /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/CMakeFiles /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/CMakeFiles/progress.marks make -f CMakeFiles/Makefile2 all make[1]: Entering directory /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0' make -f mini/CMakeFiles/mini.dir/build.make mini/CMakeFiles/mini.dir/depend make[2]: Entering directory/home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0' cd /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0 && /usr/bin/cmake -E cmake_depends "Unix Makefiles" /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0 /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/mini /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0 /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/mini /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/mini/CMakeFiles/mini.dir/DependInfo.cmake --color= make[2]: Leaving directory /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0' make -f mini/CMakeFiles/mini.dir/build.make mini/CMakeFiles/mini.dir/build make[2]: Entering directory/home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0' make[2]: Nothing to be done for mini/CMakeFiles/mini.dir/build'. make[2]: Leaving directory/home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0' /usr/bin/cmake -E cmake_progress_report /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/CMakeFiles 1 2 3 4 [ 12%] Built target mini make -f CMakeFiles/pgquarrel.dir/build.make CMakeFiles/pgquarrel.dir/depend make[2]: Entering directory /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0' cd /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0 && /usr/bin/cmake -E cmake_depends "Unix Makefiles" /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0 /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0 /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0 /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0 /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/CMakeFiles/pgquarrel.dir/DependInfo.cmake --color= make[2]: Leaving directory/home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0' make -f CMakeFiles/pgquarrel.dir/build.make CMakeFiles/pgquarrel.dir/build make[2]: Entering directory /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0' Linking C executable pgquarrel /usr/bin/cmake -E cmake_link_script CMakeFiles/pgquarrel.dir/link.txt --verbose=1 /usr/bin/cc -O0 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing -fwrapv -g CMakeFiles/pgquarrel.dir/src/aggregate.c.o CMakeFiles/pgquarrel.dir/src/cast.c.o CMakeFiles/pgquarrel.dir/src/collation.c.o CMakeFiles/pgquarrel.dir/src/common.c.o CMakeFiles/pgquarrel.dir/src/conversion.c.o CMakeFiles/pgquarrel.dir/src/domain.c.o CMakeFiles/pgquarrel.dir/src/eventtrigger.c.o CMakeFiles/pgquarrel.dir/src/extension.c.o CMakeFiles/pgquarrel.dir/src/fdw.c.o CMakeFiles/pgquarrel.dir/src/function.c.o CMakeFiles/pgquarrel.dir/src/index.c.o CMakeFiles/pgquarrel.dir/src/language.c.o CMakeFiles/pgquarrel.dir/src/matview.c.o CMakeFiles/pgquarrel.dir/src/operator.c.o CMakeFiles/pgquarrel.dir/src/privileges.c.o CMakeFiles/pgquarrel.dir/src/quarrel.c.o CMakeFiles/pgquarrel.dir/src/rule.c.o CMakeFiles/pgquarrel.dir/src/schema.c.o CMakeFiles/pgquarrel.dir/src/sequence.c.o CMakeFiles/pgquarrel.dir/src/server.c.o CMakeFiles/pgquarrel.dir/src/statistics.c.o CMakeFiles/pgquarrel.dir/src/table.c.o CMakeFiles/pgquarrel.dir/src/textsearch.c.o CMakeFiles/pgquarrel.dir/src/trigger.c.o CMakeFiles/pgquarrel.dir/src/type.c.o CMakeFiles/pgquarrel.dir/src/usermapping.c.o CMakeFiles/pgquarrel.dir/src/view.c.o -o pgquarrel -rdynamic -lpq mini/libmini.so -Wl,-rpath,/home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/mini: CMakeFiles/pgquarrel.dir/src/quarrel.c.o: In functionconnectDatabase': /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/src/quarrel.c:666: undefined reference to PQconnectdbParams' collect2: ld returned 1 exit status make[2]: *** [pgquarrel] Error 1 make[2]: Leaving directory/home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0' make[1]: [CMakeFiles/pgquarrel.dir/all] Error 2 make[1]: Leaving directory `/home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0' make: [all] Error 2

eulerto commented 6 years ago

Try:

/usr/bin/cc -O0 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing -fwrapv -g CMakeFiles/pgquarrel.dir/src/aggregate.c.o CMakeFiles/pgquarrel.dir/src/cast.c.o CMakeFiles/pgquarrel.dir/src/collation.c.o CMakeFiles/pgquarrel.dir/src/common.c.o CMakeFiles/pgquarrel.dir/src/conversion.c.o CMakeFiles/pgquarrel.dir/src/domain.c.o CMakeFiles/pgquarrel.dir/src/eventtrigger.c.o CMakeFiles/pgquarrel.dir/src/extension.c.o CMakeFiles/pgquarrel.dir/src/fdw.c.o CMakeFiles/pgquarrel.dir/src/function.c.o CMakeFiles/pgquarrel.dir/src/index.c.o CMakeFiles/pgquarrel.dir/src/language.c.o CMakeFiles/pgquarrel.dir/src/matview.c.o CMakeFiles/pgquarrel.dir/src/operator.c.o CMakeFiles/pgquarrel.dir/src/privileges.c.o CMakeFiles/pgquarrel.dir/src/quarrel.c.o CMakeFiles/pgquarrel.dir/src/rule.c.o CMakeFiles/pgquarrel.dir/src/schema.c.o CMakeFiles/pgquarrel.dir/src/sequence.c.o CMakeFiles/pgquarrel.dir/src/server.c.o CMakeFiles/pgquarrel.dir/src/statistics.c.o CMakeFiles/pgquarrel.dir/src/table.c.o CMakeFiles/pgquarrel.dir/src/textsearch.c.o CMakeFiles/pgquarrel.dir/src/trigger.c.o CMakeFiles/pgquarrel.dir/src/type.c.o CMakeFiles/pgquarrel.dir/src/usermapping.c.o CMakeFiles/pgquarrel.dir/src/view.c.o -o pgquarrel -rdynamic -lpq mini/libmini.so -Wl,-rpath,/home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/mini -L/u01/PostgreSQL/9.6/lib

charan4599 commented 6 years ago

it exited out

[postgres@VITECH-DB-PGGOLDQA pgquarrel-pgquarrel_0_4_0]$ /usr/bin/cc -O0 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing -fwrapv -g CMakeFiles/pgquarrel.dir/src/aggregate.c.o CMakeFiles/pgquarrel.dir/src/cast.c.o CMakeFiles/pgquarrel.dir/src/collation.c.o CMakeFiles/pgquarrel.dir/src/common.c.o CMakeFiles/pgquarrel.dir/src/conversion.c.o CMakeFiles/pgquarrel.dir/src/domain.c.o CMakeFiles/pgquarrel.dir/src/eventtrigger.c.o CMakeFiles/pgquarrel.dir/src/extension.c.o CMakeFiles/pgquarrel.dir/src/fdw.c.o CMakeFiles/pgquarrel.dir/src/function.c.o CMakeFiles/pgquarrel.dir/src/index.c.o CMakeFiles/pgquarrel.dir/src/language.c.o CMakeFiles/pgquarrel.dir/src/matview.c.o CMakeFiles/pgquarrel.dir/src/operator.c.o CMakeFiles/pgquarrel.dir/src/privileges.c.o CMakeFiles/pgquarrel.dir/src/quarrel.c.o CMakeFiles/pgquarrel.dir/src/rule.c.o CMakeFiles/pgquarrel.dir/src/schema.c.o CMakeFiles/pgquarrel.dir/src/sequence.c.o CMakeFiles/pgquarrel.dir/src/server.c.o CMakeFiles/pgquarrel.dir/src/statistics.c.o CMakeFiles/pgquarrel.dir/src/table.c.o CMakeFiles/pgquarrel.dir/src/textsearch.c.o CMakeFiles/pgquarrel.dir/src/trigger.c.o CMakeFiles/pgquarrel.dir/src/type.c.o CMakeFiles/pgquarrel.dir/src/usermapping.c.o CMakeFiles/pgquarrel.dir/src/view.c.o -o pgquarrel -rdynamic -lpq mini/libmini.so -Wl,-rpath,/home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/mini -L/u01/PostgreSQL/9.6/lib /usr/bin/ld: warning: libssl.so.1.0.0, needed by /u01/PostgreSQL/9.6/lib/libpq.so, not found (try using -rpath or -rpath-link) /usr/bin/ld: warning: libcrypto.so.1.0.0, needed by /u01/PostgreSQL/9.6/lib/libpq.so, not found (try using -rpath or -rpath-link) /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to SSL_set_ex_data' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference toSSL_connect' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to BIO_s_socket' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference toSSL_set_bio' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to X509_STORE_load_locations' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference tosk_free' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to SSL_get_current_compression' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference toCRYPTO_set_locking_callback' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to ASN1_STRING_length' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference toX509_NAME_get_index_by_NID' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to sk_value' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference toSSL_ctrl' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to SSL_load_error_strings' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference toSSL_CIPHER_get_bits' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to SSL_check_private_key' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference toCRYPTO_get_id_callback' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to X509_STORE_set_flags' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference toBIO_clear_flags' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to SSL_CTX_use_certificate_chain_file' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference toSSL_use_PrivateKey_file' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to SSL_get_peer_certificate' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference toBIO_new' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to X509_get_subject_name' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference toSSL_free' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to ERR_clear_error' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference toX509_NAME_get_entry' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to X509_get_ext_d2i' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference toSSL_CTX_new' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to BIO_set_flags' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference toSSL_read' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to SSL_pending' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference toSSL_get_current_cipher' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to ENGINE_load_private_key' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference toCRYPTO_num_locks' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to ENGINE_finish' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference toSSL_CTX_load_verify_locations' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to SSL_CIPHER_get_name' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference toERR_get_error' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to ERR_reason_error_string' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference tosk_num' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to ASN1_STRING_data' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference toSSL_library_init' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to CRYPTO_get_locking_callback' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference toCRYPTO_set_id_callback' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to SSL_new' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference toSSL_write' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to OPENSSL_config' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference toSSL_CTX_get_cert_store' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to X509_free' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference toSSL_set_verify' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to SSL_shutdown' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference toSSL_get_version' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to ENGINE_free' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference toBIO_int_ctrl' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to SSL_use_PrivateKey' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference toSSL_CTX_ctrl' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to X509_NAME_ENTRY_get_data' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference toSSL_get_error' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to ENGINE_by_id' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference toERR_put_error' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to SSL_CTX_free' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference toENGINE_init' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to `SSLv23_method' collect2: ld returned 1 exit status [postgres@VITECH-DB-PGGOLDQA pgquarrel-pgquarrel_0_4_0]$

eulerto commented 6 years ago

/u01/PostgreSQL/9.6/lib/libpq.so exists? ls -la /u01/PostgreSQL/9.6/lib

Ensure you clean up the tree before each attempt.

rm -rf CMakeFiles/ CMakeCache.txt cmake_install.cmake Makefile mini/CMakeFiles/ mini/cmake_install.cmake mini/Makefile
cmake -DCMAKE_INSTALL_PREFIX=/tmp/foo -DCMAKE_PREFIX_PATH=/u01/PostgreSQL/9.6 .
make VERBOSE=1

If it does not work, uncomment line 102 CMakeLists.txt and try again.

set_target_properties(pgquarrel PROPERTIES LINK_FLAGS "-L${PostgreSQL_LIBRARY_DIRS}")

charan4599 commented 6 years ago

it still fails

[postgres@VITECH-DB-PGGOLDQA pgquarrel-pgquarrel_0_4_0]$ ls -la /u01/PostgreSQL/9.6/lib total 13480 drwxr-xr-x. 4 root daemon 4096 May 8 03:46 . drwxr-xr-x. 14 root daemon 4096 May 8 03:46 .. -rwxr-xr-x. 1 root daemon 12728 Dec 13 2017 libcom_err.so.3 -rwxr-xr-x. 1 root daemon 2590837 Dec 13 2017 libcrypto.so.1.0.0 lrwxrwxrwx. 1 root root 16 May 8 03:46 libcurl.so -> libcurl.so.4.4.0 lrwxrwxrwx. 1 root root 16 May 8 03:46 libcurl.so.4 -> libcurl.so.4.4.0 -rwxr-xr-x. 1 root daemon 418296 Dec 13 2017 libcurl.so.4.4.0 -rw-r--r--. 1 root daemon 441248 Dec 13 2017 libecpg.a -rw-r--r--. 1 root daemon 54724 Dec 13 2017 libecpg_compat.a lrwxrwxrwx. 1 root root 21 May 8 03:46 libecpg_compat.so -> libecpg_compat.so.3.8 lrwxrwxrwx. 1 root root 21 May 8 03:46 libecpg_compat.so.3 -> libecpg_compat.so.3.8 -rwxr-xr-x. 1 root daemon 18304 Dec 13 2017 libecpg_compat.so.3.8 lrwxrwxrwx. 1 root root 14 May 8 03:46 libecpg.so -> libecpg.so.6.8 lrwxrwxrwx. 1 root root 14 May 8 03:46 libecpg.so.6 -> libecpg.so.6.8 -rwxr-xr-x. 1 root daemon 78320 Dec 13 2017 libecpg.so.6.8 -rwxr-xr-x. 1 root daemon 224128 Dec 13 2017 libedit.so.0 -rwxr-xr-x. 1 root daemon 369640 Dec 13 2017 libgssapi_krb5.so.2 -rwxr-xr-x. 1 root daemon 978128 Dec 13 2017 libiconv.so.2 -rwxr-xr-x. 1 root daemon 282552 Dec 13 2017 libk5crypto.so.3 -rwxr-xr-x. 1 root daemon 1004712 Dec 13 2017 libkrb5.so.3 -rwxr-xr-x. 1 root daemon 53048 Dec 13 2017 libkrb5support.so.0 -rwxr-xr-x. 1 root daemon 66360 Dec 13 2017 liblber-2.4.so.2 -rwxr-xr-x. 1 root daemon 362416 Dec 13 2017 libldap-2.4.so.2 -rwxr-xr-x. 1 root daemon 391888 Dec 13 2017 libldap_r-2.4.so.2 -rwxr-xr-x. 1 root daemon 408616 Dec 13 2017 libncurses.so.6 -rw-r--r--. 1 root daemon 199526 Dec 13 2017 libpgcommon.a -rw-r--r--. 1 root daemon 334216 Dec 13 2017 libpgfeutils.a -rw-r--r--. 1 root daemon 280030 Dec 13 2017 libpgport.a -rw-r--r--. 1 root daemon 271072 Dec 13 2017 libpgtypes.a lrwxrwxrwx. 1 root root 17 May 8 03:46 libpgtypes.so -> libpgtypes.so.3.7 lrwxrwxrwx. 1 root root 17 May 8 03:46 libpgtypes.so.3 -> libpgtypes.so.3.7 -rwxr-xr-x. 1 root daemon 66512 Dec 13 2017 libpgtypes.so.3.7 -rw-r--r--. 1 root daemon 1600798 Dec 13 2017 libpq.a lrwxrwxrwx. 1 root root 12 May 8 03:46 libpq.so -> libpq.so.5.9 lrwxrwxrwx. 1 root root 12 May 8 03:46 libpq.so.5 -> libpq.so.5.9 -rwxr-xr-x. 1 root daemon 190192 Dec 13 2017 libpq.so.5.9 -rwxr-xr-x. 1 root daemon 140480 Dec 13 2017 libsasl2.so.3 -rwxr-xr-x. 1 root daemon 512608 Dec 13 2017 libssl.so.1.0.0 -rwxr-xr-x. 1 root daemon 57136 Dec 13 2017 libuuid.so.16 -rwxr-xr-x. 1 root daemon 1875824 Dec 13 2017 libxml2.so.2 -rwxr-xr-x. 1 root daemon 330216 Dec 13 2017 libxslt.so.1 -rwxr-xr-x. 1 root daemon 114024 Dec 13 2017 libz.so.1 drwxr-xr-x. 2 root daemon 4096 Feb 2 08:49 pkgconfig drwxr-xr-x. 3 root daemon 4096 Jul 11 17:47 postgresql [postgres@VITECH-DB-PGGOLDQA pgquarrel-pgquarrel_0_4_0]$ rm -rf CMakeFiles/ CMakeCache.txt cmake_install.cmake Makefile mini/CMakeFiles/ mini/cmake_install.cmake mini/Makefile [postgres@VITECH-DB-PGGOLDQA pgquarrel-pgquarrel_0_4_0]$ cmake -DCMAKE_INSTALL_PREFIX=/tmp/foo -DCMAKE_PREFIX_PATH=/u01/PostgreSQL/9.6 . -- The C compiler identification is GNU 4.4.7 -- Check for working C compiler: /usr/bin/cc -- Check for working C compiler: /usr/bin/cc -- works -- Detecting C compiler ABI info -- Detecting C compiler ABI info - done -- Found PostgreSQL: /u01/PostgreSQL/9.6/lib (found version "9.6.6") -- PostgreSQL include dirs: /u01/PostgreSQL/9.6/include;/u01/PostgreSQL/9.6/include/postgresql/server -- PostgreSQL library dirs: /u01/PostgreSQL/9.6/lib -- PostgreSQL libraries: pq -- Configuring done -- Generating done -- Build files have been written to: /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0 [postgres@VITECH-DB-PGGOLDQA pgquarrel-pgquarrel_0_4_0]$ make VERBOSE=1 /usr/bin/cmake -H/home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0 -B/home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0 --check-build-system CMakeFiles/Makefile.cmake 0 /usr/bin/cmake -E cmake_progress_start /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/CMakeFiles /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/CMakeFiles/progress.marks make -f CMakeFiles/Makefile2 all make[1]: Entering directory /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0' make -f mini/CMakeFiles/mini.dir/build.make mini/CMakeFiles/mini.dir/depend make[2]: Entering directory/home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0' cd /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0 && /usr/bin/cmake -E cmake_depends "Unix Makefiles" /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0 /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/mini /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0 /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/mini /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/mini/CMakeFiles/mini.dir/DependInfo.cmake --color= Dependee "/home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/mini/CMakeFiles/mini.dir/DependInfo.cmake" is newer than depender "/home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/mini/CMakeFiles/mini.dir/depend.internal". Dependee "/home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/mini/CMakeFiles/CMakeDirectoryInformation.cmake" is newer than depender "/home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/mini/CMakeFiles/mini.dir/depend.internal". Scanning dependencies of target mini make[2]: Leaving directory /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0' make -f mini/CMakeFiles/mini.dir/build.make mini/CMakeFiles/mini.dir/build make[2]: Entering directory/home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0' /usr/bin/cmake -E cmake_progress_report /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/CMakeFiles 1 [ 3%] Building C object mini/CMakeFiles/mini.dir/mini-file.c.o cd /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/mini && /usr/bin/cc -Dmini_EXPORTS -fPIC -o CMakeFiles/mini.dir/mini-file.c.o -c /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/mini/mini-file.c /usr/bin/cmake -E cmake_progress_report /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/CMakeFiles 2 [ 6%] Building C object mini/CMakeFiles/mini.dir/mini-parser.c.o cd /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/mini && /usr/bin/cc -Dmini_EXPORTS -fPIC -o CMakeFiles/mini.dir/mini-parser.c.o -c /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/mini/mini-parser.c /usr/bin/cmake -E cmake_progress_report /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/CMakeFiles 3 [ 9%] Building C object mini/CMakeFiles/mini.dir/mini-readline.c.o cd /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/mini && /usr/bin/cc -Dmini_EXPORTS -fPIC -o CMakeFiles/mini.dir/mini-readline.c.o -c /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/mini/mini-readline.c /usr/bin/cmake -E cmake_progress_report /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/CMakeFiles 4 [ 12%] Building C object mini/CMakeFiles/mini.dir/mini-strip.c.o cd /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/mini && /usr/bin/cc -Dmini_EXPORTS -fPIC -o CMakeFiles/mini.dir/mini-strip.c.o -c /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/mini/mini-strip.c Linking C shared library libmini.so cd /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/mini && /usr/bin/cmake -E cmake_link_script CMakeFiles/mini.dir/link.txt --verbose=1 /usr/bin/cc -fPIC -shared -Wl,-soname,libmini.so -o libmini.so CMakeFiles/mini.dir/mini-file.c.o CMakeFiles/mini.dir/mini-parser.c.o CMakeFiles/mini.dir/mini-readline.c.o CMakeFiles/mini.dir/mini-strip.c.o make[2]: Leaving directory /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0' /usr/bin/cmake -E cmake_progress_report /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/CMakeFiles 1 2 3 4 [ 12%] Built target mini make -f CMakeFiles/pgquarrel.dir/build.make CMakeFiles/pgquarrel.dir/depend make[2]: Entering directory/home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0' cd /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0 && /usr/bin/cmake -E cmake_depends "Unix Makefiles" /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0 /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0 /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0 /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0 /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/CMakeFiles/pgquarrel.dir/DependInfo.cmake --color= Dependee "/home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/CMakeFiles/pgquarrel.dir/DependInfo.cmake" is newer than depender "/home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/CMakeFiles/pgquarrel.dir/depend.internal". Dependee "/home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/CMakeFiles/CMakeDirectoryInformation.cmake" is newer than depender "/home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/CMakeFiles/pgquarrel.dir/depend.internal". Scanning dependencies of target pgquarrel make[2]: Leaving directory /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0' make -f CMakeFiles/pgquarrel.dir/build.make CMakeFiles/pgquarrel.dir/build make[2]: Entering directory/home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0' /usr/bin/cmake -E cmake_progress_report /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/CMakeFiles 5 [ 16%] Building C object CMakeFiles/pgquarrel.dir/src/aggregate.c.o /usr/bin/cc -O0 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing -fwrapv -g -I/u01/PostgreSQL/9.6/include -I/u01/PostgreSQL/9.6/include/postgresql/server -I/home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/mini -o CMakeFiles/pgquarrel.dir/src/aggregate.c.o -c /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/src/aggregate.c /usr/bin/cmake -E cmake_progress_report /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/CMakeFiles 6 [ 19%] Building C object CMakeFiles/pgquarrel.dir/src/cast.c.o /usr/bin/cc -O0 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing -fwrapv -g -I/u01/PostgreSQL/9.6/include -I/u01/PostgreSQL/9.6/include/postgresql/server -I/home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/mini -o CMakeFiles/pgquarrel.dir/src/cast.c.o -c /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/src/cast.c /usr/bin/cmake -E cmake_progress_report /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/CMakeFiles 7 [ 22%] Building C object CMakeFiles/pgquarrel.dir/src/collation.c.o /usr/bin/cc -O0 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing -fwrapv -g -I/u01/PostgreSQL/9.6/include -I/u01/PostgreSQL/9.6/include/postgresql/server -I/home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/mini -o CMakeFiles/pgquarrel.dir/src/collation.c.o -c /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/src/collation.c /usr/bin/cmake -E cmake_progress_report /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/CMakeFiles 8 [ 25%] Building C object CMakeFiles/pgquarrel.dir/src/common.c.o /usr/bin/cc -O0 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing -fwrapv -g -I/u01/PostgreSQL/9.6/include -I/u01/PostgreSQL/9.6/include/postgresql/server -I/home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/mini -o CMakeFiles/pgquarrel.dir/src/common.c.o -c /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/src/common.c /usr/bin/cmake -E cmake_progress_report /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/CMakeFiles 9 [ 29%] Building C object CMakeFiles/pgquarrel.dir/src/conversion.c.o /usr/bin/cc -O0 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing -fwrapv -g -I/u01/PostgreSQL/9.6/include -I/u01/PostgreSQL/9.6/include/postgresql/server -I/home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/mini -o CMakeFiles/pgquarrel.dir/src/conversion.c.o -c /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/src/conversion.c /usr/bin/cmake -E cmake_progress_report /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/CMakeFiles 10 [ 32%] Building C object CMakeFiles/pgquarrel.dir/src/domain.c.o /usr/bin/cc -O0 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing -fwrapv -g -I/u01/PostgreSQL/9.6/include -I/u01/PostgreSQL/9.6/include/postgresql/server -I/home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/mini -o CMakeFiles/pgquarrel.dir/src/domain.c.o -c /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/src/domain.c /usr/bin/cmake -E cmake_progress_report /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/CMakeFiles 11 [ 35%] Building C object CMakeFiles/pgquarrel.dir/src/eventtrigger.c.o /usr/bin/cc -O0 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing -fwrapv -g -I/u01/PostgreSQL/9.6/include -I/u01/PostgreSQL/9.6/include/postgresql/server -I/home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/mini -o CMakeFiles/pgquarrel.dir/src/eventtrigger.c.o -c /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/src/eventtrigger.c /usr/bin/cmake -E cmake_progress_report /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/CMakeFiles 12 [ 38%] Building C object CMakeFiles/pgquarrel.dir/src/extension.c.o /usr/bin/cc -O0 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing -fwrapv -g -I/u01/PostgreSQL/9.6/include -I/u01/PostgreSQL/9.6/include/postgresql/server -I/home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/mini -o CMakeFiles/pgquarrel.dir/src/extension.c.o -c /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/src/extension.c /usr/bin/cmake -E cmake_progress_report /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/CMakeFiles 13 [ 41%] Building C object CMakeFiles/pgquarrel.dir/src/fdw.c.o /usr/bin/cc -O0 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing -fwrapv -g -I/u01/PostgreSQL/9.6/include -I/u01/PostgreSQL/9.6/include/postgresql/server -I/home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/mini -o CMakeFiles/pgquarrel.dir/src/fdw.c.o -c /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/src/fdw.c /usr/bin/cmake -E cmake_progress_report /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/CMakeFiles 14 [ 45%] Building C object CMakeFiles/pgquarrel.dir/src/function.c.o /usr/bin/cc -O0 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing -fwrapv -g -I/u01/PostgreSQL/9.6/include -I/u01/PostgreSQL/9.6/include/postgresql/server -I/home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/mini -o CMakeFiles/pgquarrel.dir/src/function.c.o -c /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/src/function.c /usr/bin/cmake -E cmake_progress_report /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/CMakeFiles 15 [ 48%] Building C object CMakeFiles/pgquarrel.dir/src/index.c.o /usr/bin/cc -O0 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing -fwrapv -g -I/u01/PostgreSQL/9.6/include -I/u01/PostgreSQL/9.6/include/postgresql/server -I/home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/mini -o CMakeFiles/pgquarrel.dir/src/index.c.o -c /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/src/index.c /usr/bin/cmake -E cmake_progress_report /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/CMakeFiles 16 [ 51%] Building C object CMakeFiles/pgquarrel.dir/src/language.c.o /usr/bin/cc -O0 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing -fwrapv -g -I/u01/PostgreSQL/9.6/include -I/u01/PostgreSQL/9.6/include/postgresql/server -I/home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/mini -o CMakeFiles/pgquarrel.dir/src/language.c.o -c /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/src/language.c /usr/bin/cmake -E cmake_progress_report /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/CMakeFiles 17 [ 54%] Building C object CMakeFiles/pgquarrel.dir/src/matview.c.o /usr/bin/cc -O0 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing -fwrapv -g -I/u01/PostgreSQL/9.6/include -I/u01/PostgreSQL/9.6/include/postgresql/server -I/home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/mini -o CMakeFiles/pgquarrel.dir/src/matview.c.o -c /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/src/matview.c /usr/bin/cmake -E cmake_progress_report /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/CMakeFiles 18 [ 58%] Building C object CMakeFiles/pgquarrel.dir/src/operator.c.o /usr/bin/cc -O0 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing -fwrapv -g -I/u01/PostgreSQL/9.6/include -I/u01/PostgreSQL/9.6/include/postgresql/server -I/home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/mini -o CMakeFiles/pgquarrel.dir/src/operator.c.o -c /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/src/operator.c /usr/bin/cmake -E cmake_progress_report /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/CMakeFiles 19 [ 61%] Building C object CMakeFiles/pgquarrel.dir/src/privileges.c.o /usr/bin/cc -O0 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing -fwrapv -g -I/u01/PostgreSQL/9.6/include -I/u01/PostgreSQL/9.6/include/postgresql/server -I/home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/mini -o CMakeFiles/pgquarrel.dir/src/privileges.c.o -c /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/src/privileges.c /usr/bin/cmake -E cmake_progress_report /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/CMakeFiles 20 [ 64%] Building C object CMakeFiles/pgquarrel.dir/src/quarrel.c.o /usr/bin/cc -O0 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing -fwrapv -g -I/u01/PostgreSQL/9.6/include -I/u01/PostgreSQL/9.6/include/postgresql/server -I/home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/mini -o CMakeFiles/pgquarrel.dir/src/quarrel.c.o -c /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/src/quarrel.c /usr/bin/cmake -E cmake_progress_report /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/CMakeFiles 21 [ 67%] Building C object CMakeFiles/pgquarrel.dir/src/rule.c.o /usr/bin/cc -O0 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing -fwrapv -g -I/u01/PostgreSQL/9.6/include -I/u01/PostgreSQL/9.6/include/postgresql/server -I/home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/mini -o CMakeFiles/pgquarrel.dir/src/rule.c.o -c /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/src/rule.c /usr/bin/cmake -E cmake_progress_report /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/CMakeFiles 22 [ 70%] Building C object CMakeFiles/pgquarrel.dir/src/schema.c.o /usr/bin/cc -O0 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing -fwrapv -g -I/u01/PostgreSQL/9.6/include -I/u01/PostgreSQL/9.6/include/postgresql/server -I/home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/mini -o CMakeFiles/pgquarrel.dir/src/schema.c.o -c /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/src/schema.c /usr/bin/cmake -E cmake_progress_report /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/CMakeFiles 23 [ 74%] Building C object CMakeFiles/pgquarrel.dir/src/sequence.c.o /usr/bin/cc -O0 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing -fwrapv -g -I/u01/PostgreSQL/9.6/include -I/u01/PostgreSQL/9.6/include/postgresql/server -I/home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/mini -o CMakeFiles/pgquarrel.dir/src/sequence.c.o -c /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/src/sequence.c /usr/bin/cmake -E cmake_progress_report /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/CMakeFiles 24 [ 77%] Building C object CMakeFiles/pgquarrel.dir/src/server.c.o /usr/bin/cc -O0 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing -fwrapv -g -I/u01/PostgreSQL/9.6/include -I/u01/PostgreSQL/9.6/include/postgresql/server -I/home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/mini -o CMakeFiles/pgquarrel.dir/src/server.c.o -c /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/src/server.c /usr/bin/cmake -E cmake_progress_report /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/CMakeFiles 25 [ 80%] Building C object CMakeFiles/pgquarrel.dir/src/statistics.c.o /usr/bin/cc -O0 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing -fwrapv -g -I/u01/PostgreSQL/9.6/include -I/u01/PostgreSQL/9.6/include/postgresql/server -I/home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/mini -o CMakeFiles/pgquarrel.dir/src/statistics.c.o -c /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/src/statistics.c /usr/bin/cmake -E cmake_progress_report /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/CMakeFiles 26 [ 83%] Building C object CMakeFiles/pgquarrel.dir/src/table.c.o /usr/bin/cc -O0 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing -fwrapv -g -I/u01/PostgreSQL/9.6/include -I/u01/PostgreSQL/9.6/include/postgresql/server -I/home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/mini -o CMakeFiles/pgquarrel.dir/src/table.c.o -c /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/src/table.c /usr/bin/cmake -E cmake_progress_report /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/CMakeFiles 27 [ 87%] Building C object CMakeFiles/pgquarrel.dir/src/textsearch.c.o /usr/bin/cc -O0 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing -fwrapv -g -I/u01/PostgreSQL/9.6/include -I/u01/PostgreSQL/9.6/include/postgresql/server -I/home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/mini -o CMakeFiles/pgquarrel.dir/src/textsearch.c.o -c /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/src/textsearch.c /usr/bin/cmake -E cmake_progress_report /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/CMakeFiles 28 [ 90%] Building C object CMakeFiles/pgquarrel.dir/src/trigger.c.o /usr/bin/cc -O0 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing -fwrapv -g -I/u01/PostgreSQL/9.6/include -I/u01/PostgreSQL/9.6/include/postgresql/server -I/home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/mini -o CMakeFiles/pgquarrel.dir/src/trigger.c.o -c /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/src/trigger.c /usr/bin/cmake -E cmake_progress_report /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/CMakeFiles 29 [ 93%] Building C object CMakeFiles/pgquarrel.dir/src/type.c.o /usr/bin/cc -O0 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing -fwrapv -g -I/u01/PostgreSQL/9.6/include -I/u01/PostgreSQL/9.6/include/postgresql/server -I/home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/mini -o CMakeFiles/pgquarrel.dir/src/type.c.o -c /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/src/type.c /usr/bin/cmake -E cmake_progress_report /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/CMakeFiles 30 [ 96%] Building C object CMakeFiles/pgquarrel.dir/src/usermapping.c.o /usr/bin/cc -O0 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing -fwrapv -g -I/u01/PostgreSQL/9.6/include -I/u01/PostgreSQL/9.6/include/postgresql/server -I/home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/mini -o CMakeFiles/pgquarrel.dir/src/usermapping.c.o -c /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/src/usermapping.c /usr/bin/cmake -E cmake_progress_report /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/CMakeFiles 31 [100%] Building C object CMakeFiles/pgquarrel.dir/src/view.c.o /usr/bin/cc -O0 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing -fwrapv -g -I/u01/PostgreSQL/9.6/include -I/u01/PostgreSQL/9.6/include/postgresql/server -I/home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/mini -o CMakeFiles/pgquarrel.dir/src/view.c.o -c /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/src/view.c Linking C executable pgquarrel /usr/bin/cmake -E cmake_link_script CMakeFiles/pgquarrel.dir/link.txt --verbose=1 /usr/bin/cc -O0 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing -fwrapv -g CMakeFiles/pgquarrel.dir/src/aggregate.c.o CMakeFiles/pgquarrel.dir/src/cast.c.o CMakeFiles/pgquarrel.dir/src/collation.c.o CMakeFiles/pgquarrel.dir/src/common.c.o CMakeFiles/pgquarrel.dir/src/conversion.c.o CMakeFiles/pgquarrel.dir/src/domain.c.o CMakeFiles/pgquarrel.dir/src/eventtrigger.c.o CMakeFiles/pgquarrel.dir/src/extension.c.o CMakeFiles/pgquarrel.dir/src/fdw.c.o CMakeFiles/pgquarrel.dir/src/function.c.o CMakeFiles/pgquarrel.dir/src/index.c.o CMakeFiles/pgquarrel.dir/src/language.c.o CMakeFiles/pgquarrel.dir/src/matview.c.o CMakeFiles/pgquarrel.dir/src/operator.c.o CMakeFiles/pgquarrel.dir/src/privileges.c.o CMakeFiles/pgquarrel.dir/src/quarrel.c.o CMakeFiles/pgquarrel.dir/src/rule.c.o CMakeFiles/pgquarrel.dir/src/schema.c.o CMakeFiles/pgquarrel.dir/src/sequence.c.o CMakeFiles/pgquarrel.dir/src/server.c.o CMakeFiles/pgquarrel.dir/src/statistics.c.o CMakeFiles/pgquarrel.dir/src/table.c.o CMakeFiles/pgquarrel.dir/src/textsearch.c.o CMakeFiles/pgquarrel.dir/src/trigger.c.o CMakeFiles/pgquarrel.dir/src/type.c.o CMakeFiles/pgquarrel.dir/src/usermapping.c.o CMakeFiles/pgquarrel.dir/src/view.c.o -o pgquarrel -rdynamic -lpq mini/libmini.so -Wl,-rpath,/home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/mini: CMakeFiles/pgquarrel.dir/src/quarrel.c.o: In function connectDatabase': /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/src/quarrel.c:666: undefined reference toPQconnectdbParams' collect2: ld returned 1 exit status make[2]: [pgquarrel] Error 1 make[2]: Leaving directory `/home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0' make[1]: [CMakeFiles/pgquarrel.dir/all] Error 2 make[1]: Leaving directory /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0' make: *** [all] Error 2 [postgres@VITECH-DB-PGGOLDQA pgquarrel-pgquarrel_0_4_0]$ ls -lrt total 80 drwxrwxr-x. 3 postgres postgres 4096 Jul 1 11:16 test drwxrwxr-x. 2 postgres postgres 4096 Jul 1 11:16 src -rw-rw-r--. 1 postgres postgres 10969 Jul 1 11:16 README.md -rw-rw-r--. 1 postgres postgres 1517 Jul 1 11:16 LICENSE -rw-rw-r--. 1 postgres postgres 3961 Jul 1 11:16 CMakeLists.txt -rw-rw-r--. 1 postgres postgres 11949 Jul 16 17:25 CMakeCache.txt -rw-rw-r--. 1 postgres postgres 27116 Jul 16 17:25 Makefile -rw-rw-r--. 1 postgres postgres 2862 Jul 16 17:25 cmake_install.cmake drwxrwxr-x. 7 postgres postgres 4096 Jul 16 17:25 CMakeFiles drwxrwxr-x. 3 postgres postgres 4096 Jul 16 17:25 mini [postgres@VITECH-DB-PGGOLDQA pgquarrel-pgquarrel_0_4_0]$ vi CMakeLists.txt [postgres@VITECH-DB-PGGOLDQA pgquarrel-pgquarrel_0_4_0]$ make VERBOSE=1 /usr/bin/cmake -H/home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0 -B/home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0 --check-build-system CMakeFiles/Makefile.cmake 0 Re-run cmake file: Makefile older than: CMakeLists.txt -- PostgreSQL include dirs: /u01/PostgreSQL/9.6/include;/u01/PostgreSQL/9.6/include/postgresql/server -- PostgreSQL library dirs: /u01/PostgreSQL/9.6/lib -- PostgreSQL libraries: pq -- Configuring done -- Generating done -- Build files have been written to: /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0 /usr/bin/cmake -E cmake_progress_start /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/CMakeFiles /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/CMakeFiles/progress.marks make -f CMakeFiles/Makefile2 all make[1]: Entering directory/home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0' make -f mini/CMakeFiles/mini.dir/build.make mini/CMakeFiles/mini.dir/depend make[2]: Entering directory /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0' cd /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0 && /usr/bin/cmake -E cmake_depends "Unix Makefiles" /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0 /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/mini /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0 /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/mini /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/mini/CMakeFiles/mini.dir/DependInfo.cmake --color= make[2]: Leaving directory/home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0' make -f mini/CMakeFiles/mini.dir/build.make mini/CMakeFiles/mini.dir/build make[2]: Entering directory /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0' make[2]: Nothing to be done formini/CMakeFiles/mini.dir/build'. make[2]: Leaving directory /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0' /usr/bin/cmake -E cmake_progress_report /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/CMakeFiles 1 2 3 4 [ 12%] Built target mini make -f CMakeFiles/pgquarrel.dir/build.make CMakeFiles/pgquarrel.dir/depend make[2]: Entering directory/home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0' cd /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0 && /usr/bin/cmake -E cmake_depends "Unix Makefiles" /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0 /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0 /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0 /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0 /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/CMakeFiles/pgquarrel.dir/DependInfo.cmake --color= make[2]: Leaving directory /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0' make -f CMakeFiles/pgquarrel.dir/build.make CMakeFiles/pgquarrel.dir/build make[2]: Entering directory/home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0' Linking C executable pgquarrel /usr/bin/cmake -E cmake_link_script CMakeFiles/pgquarrel.dir/link.txt --verbose=1 /usr/bin/cc -O0 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing -fwrapv -g -L/u01/PostgreSQL/9.6/lib CMakeFiles/pgquarrel.dir/src/aggregate.c.o CMakeFiles/pgquarrel.dir/src/cast.c.o CMakeFiles/pgquarrel.dir/src/collation.c.o CMakeFiles/pgquarrel.dir/src/common.c.o CMakeFiles/pgquarrel.dir/src/conversion.c.o CMakeFiles/pgquarrel.dir/src/domain.c.o CMakeFiles/pgquarrel.dir/src/eventtrigger.c.o CMakeFiles/pgquarrel.dir/src/extension.c.o CMakeFiles/pgquarrel.dir/src/fdw.c.o CMakeFiles/pgquarrel.dir/src/function.c.o CMakeFiles/pgquarrel.dir/src/index.c.o CMakeFiles/pgquarrel.dir/src/language.c.o CMakeFiles/pgquarrel.dir/src/matview.c.o CMakeFiles/pgquarrel.dir/src/operator.c.o CMakeFiles/pgquarrel.dir/src/privileges.c.o CMakeFiles/pgquarrel.dir/src/quarrel.c.o CMakeFiles/pgquarrel.dir/src/rule.c.o CMakeFiles/pgquarrel.dir/src/schema.c.o CMakeFiles/pgquarrel.dir/src/sequence.c.o CMakeFiles/pgquarrel.dir/src/server.c.o CMakeFiles/pgquarrel.dir/src/statistics.c.o CMakeFiles/pgquarrel.dir/src/table.c.o CMakeFiles/pgquarrel.dir/src/textsearch.c.o CMakeFiles/pgquarrel.dir/src/trigger.c.o CMakeFiles/pgquarrel.dir/src/type.c.o CMakeFiles/pgquarrel.dir/src/usermapping.c.o CMakeFiles/pgquarrel.dir/src/view.c.o -o pgquarrel -rdynamic -lpq mini/libmini.so -Wl,-rpath,/home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/mini: /usr/bin/ld: warning: libssl.so.1.0.0, needed by /u01/PostgreSQL/9.6/lib/libpq.so, not found (try using -rpath or -rpath-link) /usr/bin/ld: warning: libcrypto.so.1.0.0, needed by /u01/PostgreSQL/9.6/lib/libpq.so, not found (try using -rpath or -rpath-link) /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to SSL_set_ex_data' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference toSSL_connect' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to BIO_s_socket' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference toSSL_set_bio' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to X509_STORE_load_locations' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference tosk_free' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to SSL_get_current_compression' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference toCRYPTO_set_locking_callback' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to ASN1_STRING_length' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference toX509_NAME_get_index_by_NID' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to sk_value' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference toSSL_ctrl' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to SSL_load_error_strings' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference toSSL_CIPHER_get_bits' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to SSL_check_private_key' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference toCRYPTO_get_id_callback' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to X509_STORE_set_flags' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference toBIO_clear_flags' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to SSL_CTX_use_certificate_chain_file' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference toSSL_use_PrivateKey_file' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to SSL_get_peer_certificate' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference toBIO_new' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to X509_get_subject_name' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference toSSL_free' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to ERR_clear_error' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference toX509_NAME_get_entry' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to X509_get_ext_d2i' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference toSSL_CTX_new' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to BIO_set_flags' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference toSSL_read' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to SSL_pending' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference toSSL_get_current_cipher' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to ENGINE_load_private_key' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference toCRYPTO_num_locks' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to ENGINE_finish' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference toSSL_CTX_load_verify_locations' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to SSL_CIPHER_get_name' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference toERR_get_error' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to ERR_reason_error_string' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference tosk_num' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to ASN1_STRING_data' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference toSSL_library_init' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to CRYPTO_get_locking_callback' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference toCRYPTO_set_id_callback' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to SSL_new' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference toSSL_write' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to OPENSSL_config' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference toSSL_CTX_get_cert_store' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to X509_free' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference toSSL_set_verify' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to SSL_shutdown' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference toSSL_get_version' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to ENGINE_free' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference toBIO_int_ctrl' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to SSL_use_PrivateKey' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference toSSL_CTX_ctrl' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to X509_NAME_ENTRY_get_data' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference toSSL_get_error' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to ENGINE_by_id' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference toERR_put_error' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to SSL_CTX_free' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference toENGINE_init' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to SSLv23_method' collect2: ld returned 1 exit status make[2]: *** [pgquarrel] Error 1 make[2]: Leaving directory/home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0' make[1]: [CMakeFiles/pgquarrel.dir/all] Error 2 make[1]: Leaving directory `/home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0' make: [all] Error 2 [postgres@VITECH-DB-PGGOLDQA pgquarrel-pgquarrel_0_4_0]$ cmake -DCMAKE_INSTALL_PREFIX=/tmp/foo -DCMAKE_PREFIX_PATH=/u01/PostgreSQL/9.6 . -- PostgreSQL include dirs: /u01/PostgreSQL/9.6/include;/u01/PostgreSQL/9.6/include/postgresql/server -- PostgreSQL library dirs: /u01/PostgreSQL/9.6/lib -- PostgreSQL libraries: pq -- Configuring done -- Generating done -- Build files have been written to: /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0 [postgres@VITECH-DB-PGGOLDQA pgquarrel-pgquarrel_0_4_0]$ make VERBOSE=1 /usr/bin/cmake -H/home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0 -B/home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0 --check-build-system CMakeFiles/Makefile.cmake 0 /usr/bin/cmake -E cmake_progress_start /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/CMakeFiles /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/CMakeFiles/progress.marks make -f CMakeFiles/Makefile2 all make[1]: Entering directory /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0' make -f mini/CMakeFiles/mini.dir/build.make mini/CMakeFiles/mini.dir/depend make[2]: Entering directory/home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0' cd /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0 && /usr/bin/cmake -E cmake_depends "Unix Makefiles" /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0 /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/mini /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0 /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/mini /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/mini/CMakeFiles/mini.dir/DependInfo.cmake --color= make[2]: Leaving directory /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0' make -f mini/CMakeFiles/mini.dir/build.make mini/CMakeFiles/mini.dir/build make[2]: Entering directory/home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0' make[2]: Nothing to be done for mini/CMakeFiles/mini.dir/build'. make[2]: Leaving directory/home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0' /usr/bin/cmake -E cmake_progress_report /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/CMakeFiles 1 2 3 4 [ 12%] Built target mini make -f CMakeFiles/pgquarrel.dir/build.make CMakeFiles/pgquarrel.dir/depend make[2]: Entering directory /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0' cd /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0 && /usr/bin/cmake -E cmake_depends "Unix Makefiles" /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0 /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0 /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0 /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0 /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/CMakeFiles/pgquarrel.dir/DependInfo.cmake --color= make[2]: Leaving directory/home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0' make -f CMakeFiles/pgquarrel.dir/build.make CMakeFiles/pgquarrel.dir/build make[2]: Entering directory /home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0' Linking C executable pgquarrel /usr/bin/cmake -E cmake_link_script CMakeFiles/pgquarrel.dir/link.txt --verbose=1 /usr/bin/cc -O0 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing -fwrapv -g -L/u01/PostgreSQL/9.6/lib CMakeFiles/pgquarrel.dir/src/aggregate.c.o CMakeFiles/pgquarrel.dir/src/cast.c.o CMakeFiles/pgquarrel.dir/src/collation.c.o CMakeFiles/pgquarrel.dir/src/common.c.o CMakeFiles/pgquarrel.dir/src/conversion.c.o CMakeFiles/pgquarrel.dir/src/domain.c.o CMakeFiles/pgquarrel.dir/src/eventtrigger.c.o CMakeFiles/pgquarrel.dir/src/extension.c.o CMakeFiles/pgquarrel.dir/src/fdw.c.o CMakeFiles/pgquarrel.dir/src/function.c.o CMakeFiles/pgquarrel.dir/src/index.c.o CMakeFiles/pgquarrel.dir/src/language.c.o CMakeFiles/pgquarrel.dir/src/matview.c.o CMakeFiles/pgquarrel.dir/src/operator.c.o CMakeFiles/pgquarrel.dir/src/privileges.c.o CMakeFiles/pgquarrel.dir/src/quarrel.c.o CMakeFiles/pgquarrel.dir/src/rule.c.o CMakeFiles/pgquarrel.dir/src/schema.c.o CMakeFiles/pgquarrel.dir/src/sequence.c.o CMakeFiles/pgquarrel.dir/src/server.c.o CMakeFiles/pgquarrel.dir/src/statistics.c.o CMakeFiles/pgquarrel.dir/src/table.c.o CMakeFiles/pgquarrel.dir/src/textsearch.c.o CMakeFiles/pgquarrel.dir/src/trigger.c.o CMakeFiles/pgquarrel.dir/src/type.c.o CMakeFiles/pgquarrel.dir/src/usermapping.c.o CMakeFiles/pgquarrel.dir/src/view.c.o -o pgquarrel -rdynamic -lpq mini/libmini.so -Wl,-rpath,/home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0/mini: /usr/bin/ld: warning: libssl.so.1.0.0, needed by /u01/PostgreSQL/9.6/lib/libpq.so, not found (try using -rpath or -rpath-link) /usr/bin/ld: warning: libcrypto.so.1.0.0, needed by /u01/PostgreSQL/9.6/lib/libpq.so, not found (try using -rpath or -rpath-link) /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference toSSL_set_ex_data' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to SSL_connect' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference toBIO_s_socket' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to SSL_set_bio' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference toX509_STORE_load_locations' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to sk_free' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference toSSL_get_current_compression' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to CRYPTO_set_locking_callback' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference toASN1_STRING_length' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to X509_NAME_get_index_by_NID' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference tosk_value' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to SSL_ctrl' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference toSSL_load_error_strings' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to SSL_CIPHER_get_bits' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference toSSL_check_private_key' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to CRYPTO_get_id_callback' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference toX509_STORE_set_flags' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to BIO_clear_flags' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference toSSL_CTX_use_certificate_chain_file' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to SSL_use_PrivateKey_file' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference toSSL_get_peer_certificate' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to BIO_new' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference toX509_get_subject_name' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to SSL_free' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference toERR_clear_error' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to X509_NAME_get_entry' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference toX509_get_ext_d2i' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to SSL_CTX_new' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference toBIO_set_flags' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to SSL_read' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference toSSL_pending' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to SSL_get_current_cipher' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference toENGINE_load_private_key' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to CRYPTO_num_locks' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference toENGINE_finish' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to SSL_CTX_load_verify_locations' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference toSSL_CIPHER_get_name' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to ERR_get_error' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference toERR_reason_error_string' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to sk_num' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference toASN1_STRING_data' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to SSL_library_init' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference toCRYPTO_get_locking_callback' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to CRYPTO_set_id_callback' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference toSSL_new' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to SSL_write' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference toOPENSSL_config' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to SSL_CTX_get_cert_store' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference toX509_free' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to SSL_set_verify' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference toSSL_shutdown' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to SSL_get_version' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference toENGINE_free' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to BIO_int_ctrl' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference toSSL_use_PrivateKey' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to SSL_CTX_ctrl' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference toX509_NAME_ENTRY_get_data' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to SSL_get_error' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference toENGINE_by_id' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to ERR_put_error' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference toSSL_CTX_free' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference to ENGINE_init' /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference toSSLv23_method' collect2: ld returned 1 exit status make[2]: [pgquarrel] Error 1 make[2]: Leaving directory `/home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0' make[1]: [CMakeFiles/pgquarrel.dir/all] Error 2 make[1]: Leaving directory `/home/postgres/pgquarrel/pgquarrel-pgquarrel_0_4_0' make: *** [all] Error 2

charan4599 commented 6 years ago

i did uncomment the parameter you mentioned

charan4599 commented 6 years ago

[postgres@VITECH-DB-PGGOLDQA pgquarrel-pgquarrel_0_4_0]$ cat CMakeLists.txt | grep LINK_FLAGS set_target_properties(pgquarrel PROPERTIES LINK_FLAGS "-L${PostgreSQL_LIBRARY_DIRS}") [postgres@VITECH-DB-PGGOLDQA pgquarrel-pgquarrel_0_4_0]$

eulerto commented 6 years ago

/usr/bin/ld: warning: libssl.so.1.0.0, needed by /u01/PostgreSQL/9.6/lib/libpq.so, not found (try using -rpath or -rpath-link) /usr/bin/ld: warning: libcrypto.so.1.0.0, needed by /u01/PostgreSQL/9.6/lib/libpq.so, not found (try using -rpath or -rpath-link) /u01/PostgreSQL/9.6/lib/libpq.so: undefined reference toSSL_set_ex_data'

How do you install Postgres? Source code? It seems a libpq dependency is not found. What is the output of the following command?

ldd /u01/PostgreSQL/9.6/lib/libpq.so

Timestamp is different. Are you sure this installation is working?

lrwxrwxrwx. 1 root root 12 May 8 03:46 libpq.so -> libpq.so.5.9
lrwxrwxrwx. 1 root root 12 May 8 03:46 libpq.so.5 -> libpq.so.5.9
-rwxr-xr-x. 1 root daemon 190192 Dec 13 2017 libpq.so.5.9
-rwxr-xr-x. 1 root daemon 140480 Dec 13 2017 libsasl2.so.3
-rwxr-xr-x. 1 root daemon 512608 Dec 13 2017 libssl.so.1.0.0

Could you build a fresh 9.6 installation to test pgquarrel?

charan4599 commented 6 years ago

@eulerto sorry for the delay in response.

[postgres@VITECH-DB-PGGOLDQA pgquarrel-pgquarrel_0_4_0]$ ldd /u01/PostgreSQL/9.6/lib/libpq.so linux-vdso.so.1 => (0x00007fff5f2ae000) libssl.so.1.0.0 => /u01/PostgreSQL/9.6/lib/libssl.so.1.0.0 (0x00007f7fa3f75000) libcrypto.so.1.0.0 => /u01/PostgreSQL/9.6/lib/libcrypto.so.1.0.0 (0x00007f7fa3b3d000) libgssapi_krb5.so.2 => /u01/PostgreSQL/9.6/lib/libgssapi_krb5.so.2 (0x00007f7fa38e3000) libldap_r-2.4.so.2 => /u01/PostgreSQL/9.6/lib/libldap_r-2.4.so.2 (0x00007f7fa3681000) libpthread.so.0 => /lib64/libpthread.so.0 (0x00007f7fa3457000) libc.so.6 => /lib64/libc.so.6 (0x00007f7fa30c3000) libdl.so.2 => /lib64/libdl.so.2 (0x00007f7fa2ebf000) libkrb5.so.3 => /u01/PostgreSQL/9.6/lib/libkrb5.so.3 (0x00007f7fa2bc9000) libk5crypto.so.3 => /u01/PostgreSQL/9.6/lib/libk5crypto.so.3 (0x00007f7fa2983000) libcom_err.so.3 => /u01/PostgreSQL/9.6/lib/libcom_err.so.3 (0x00007f7fa2780000) libkrb5support.so.0 => /u01/PostgreSQL/9.6/lib/libkrb5support.so.0 (0x00007f7fa2572000) libresolv.so.2 => /lib64/libresolv.so.2 (0x00007f7fa2358000) liblber-2.4.so.2 => /u01/PostgreSQL/9.6/lib/liblber-2.4.so.2 (0x00007f7fa2148000) libsasl2.so.3 => /u01/PostgreSQL/9.6/lib/libsasl2.so.3 (0x00007f7fa1f25000) /lib64/ld-linux-x86-64.so.2 (0x0000003654600000)

the installation is working and databases are live on this server let me try this on other server, but as far as i know we have same VM configuration on all our postgres servers

charan4599 commented 6 years ago

@eulerto did you have a chance to look into this error?

eulerto commented 6 years ago

I don't. As I said, those files with different timestamps seems that your installation was overridden.

Did you check /etc/ld.so.conf? If there isn't a postgres library directory in it, try again with:

rm -rf CMakeFiles/ CMakeCache.txt cmake_install.cmake Makefile mini/CMakeFiles/ mini/cmake_install.cmake mini/Makefile
cmake -DCMAKE_INSTALL_PREFIX=/tmp/foo -DCMAKE_PREFIX_PATH=/u01/PostgreSQL/9.6 .
export LD_LIBRARY_PATH=/u01/PostgreSQL/9.6/lib
sudo ldconfig
make VERBOSE=1

If it doesn't work, build a fresh postgres 9.6 and try again.

eulerto commented 5 years ago

Commit 5ddf6a8e90947bba8e01f07a58cd6d20490aefb0 should improve cases like this.

eulerto / pgquarrel

installation issues linux #56

postgres=# select version(); version