Re: ICU is not supported in this build. install from source code.

From: jian he <jian(dot)universality(at)gmail(dot)com>
To: pgsql-general list <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: ICU is not supported in this build. install from source code.
Date: 2022-08-03 08:32:36
Message-ID: CACJufxHypCTEus2n2sy8Kr5iK=yzB1EuaS0RM416RCbCOO5Cgg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Then I try to install the latest from the latest source code.

./configure --with-perl --with-python --with-icu
ICU_CFLAGS='-I/usr/include/unicode' ICU_LIBS='-L/usr/lib/icu'
--enable-debug --with-pgport=5440

./configure.status return

config.status: creating GNUmakefile
> config.status: creating src/Makefile.global
> config.status: creating src/include/pg_config.h
> config.status: src/include/pg_config.h is unchanged
> config.status: creating src/include/pg_config_ext.h
> config.status: src/include/pg_config_ext.h is unchanged
> config.status: creating src/interfaces/ecpg/include/ecpg_config.h
> config.status: src/interfaces/ecpg/include/ecpg_config.h is unchanged
> config.status: linking src/backend/port/tas/dummy.s to
> src/backend/port/tas.s
> config.status: linking src/backend/port/posix_sema.c to
> src/backend/port/pg_sema.c
> config.status: linking src/backend/port/sysv_shmem.c to
> src/backend/port/pg_shmem.c
> config.status: linking src/include/port/linux.h to
> src/include/pg_config_os.h
> config.status: linking src/makefiles/Makefile.linux to src/Makefile.port
>

then make world
the following is make world error:

/usr/bin/ld: access/hash/hashfunc.o: in function `hashtext':
> /home/jian/Desktop/pg16_source/postgresql/src/backend/access/hash/hashfunc.c:301:
> undefined reference to `ucol_getSortKey_70'
> /usr/bin/ld:
> /home/jian/Desktop/pg16_source/postgresql/src/backend/access/hash/hashfunc.c:304:
> undefined reference to `ucol_getSortKey_70'
> /usr/bin/ld: access/hash/hashfunc.o: in function `hashtextextended':
> /home/jian/Desktop/pg16_source/postgresql/src/backend/access/hash/hashfunc.c:358:
> undefined reference to `ucol_getSortKey_70'
> /usr/bin/ld:
> /home/jian/Desktop/pg16_source/postgresql/src/backend/access/hash/hashfunc.c:361:
> undefined reference to `ucol_getSortKey_70'
> /usr/bin/ld: commands/collationcmds.o: in function
> `pg_import_system_collations':
> /home/jian/Desktop/pg16_source/postgresql/src/backend/commands/collationcmds.c:786:
> undefined reference to `uloc_getAvailable_70'
> /usr/bin/ld: commands/collationcmds.o: in function `get_icu_language_tag':
> /home/jian/Desktop/pg16_source/postgresql/src/backend/commands/collationcmds.c:529:
> undefined reference to `uloc_toLanguageTag_70'
> /usr/bin/ld: commands/collationcmds.o: in function
> `pg_import_system_collations':
> /home/jian/Desktop/pg16_source/postgresql/src/backend/commands/collationcmds.c:775:
> undefined reference to `uloc_countAvailable_70'
> /usr/bin/ld: commands/collationcmds.o: in function
> `get_icu_locale_comment':
> /home/jian/Desktop/pg16_source/postgresql/src/backend/commands/collationcmds.c:554:
> undefined reference to `uloc_getDisplayName_70'
> /usr/bin/ld: commands/collationcmds.o: in function `get_icu_language_tag':
> /home/jian/Desktop/pg16_source/postgresql/src/backend/commands/collationcmds.c:531:
> undefined reference to `u_errorName_70'
> /usr/bin/ld: regex/regcomp.o: in function `pg_wc_isalpha':
> /home/jian/Desktop/pg16_source/postgresql/src/backend/regex/regc_pg_locale.c:356:
> undefined reference to `u_isalpha_70'
> /usr/bin/ld: regex/regcomp.o: in function `pg_wc_isspace':
> /home/jian/Desktop/pg16_source/postgresql/src/backend/regex/regc_pg_locale.c:617:
> undefined reference to `u_isspace_70'
> /usr/bin/ld: regex/regcomp.o: in function `pg_wc_isdigit':
> /home/jian/Desktop/pg16_source/postgresql/src/backend/regex/regc_pg_locale.c:320:
> undefined reference to `u_isdigit_70'
> /usr/bin/ld: regex/regcomp.o: in function `pg_wc_isalnum':
> /home/jian/Desktop/pg16_source/postgresql/src/backend/regex/regc_pg_locale.c:392:
> undefined reference to `u_isalnum_70'
> /usr/bin/ld: regex/regcomp.o: in function `pg_wc_isgraph':
> /home/jian/Desktop/pg16_source/postgresql/src/backend/regex/regc_pg_locale.c:509:
> undefined reference to `u_isgraph_70'
> /usr/bin/ld: regex/regcomp.o: in function `pg_wc_isupper':
> /home/jian/Desktop/pg16_source/postgresql/src/backend/regex/regc_pg_locale.c:437:
> undefined reference to `u_isupper_70'
> /usr/bin/ld: regex/regcomp.o: in function `pg_wc_islower':
> /home/jian/Desktop/pg16_source/postgresql/src/backend/regex/regc_pg_locale.c:473:
> undefined reference to `u_islower_70'
> /usr/bin/ld: regex/regcomp.o: in function `pg_wc_ispunct':
> /home/jian/Desktop/pg16_source/postgresql/src/backend/regex/regc_pg_locale.c:581:
> undefined reference to `u_ispunct_70'
> /usr/bin/ld: regex/regcomp.o: in function `pg_wc_isprint':
> /home/jian/Desktop/pg16_source/postgresql/src/backend/regex/regc_pg_locale.c:545:
> undefined reference to `u_isprint_70'
> /usr/bin/ld: regex/regcomp.o: in function `pg_wc_tolower':
> /home/jian/Desktop/pg16_source/postgresql/src/backend/regex/regc_pg_locale.c:705:
> undefined reference to `u_tolower_70'
> /usr/bin/ld: regex/regcomp.o: in function `pg_wc_toupper':
> /home/jian/Desktop/pg16_source/postgresql/src/backend/regex/regc_pg_locale.c:661:
> undefined reference to `u_toupper_70'
> /usr/bin/ld: utils/adt/formatting.o: in function `u_strToTitle_default_BI':
> /home/jian/Desktop/pg16_source/postgresql/src/backend/utils/adt/formatting.c:1631:
> undefined reference to `u_strToTitle_70'
> /usr/bin/ld: utils/adt/formatting.o: in function `str_tolower':
> /home/jian/Desktop/pg16_source/postgresql/src/backend/utils/adt/formatting.c:1700:
> undefined reference to `u_strToLower_70'
> /usr/bin/ld: utils/adt/formatting.o: in function `str_toupper':
> /home/jian/Desktop/pg16_source/postgresql/src/backend/utils/adt/formatting.c:1822:
> undefined reference to `u_strToUpper_70'
> /usr/bin/ld: utils/adt/formatting.o: in function `icu_convert_case':
> /home/jian/Desktop/pg16_source/postgresql/src/backend/utils/adt/formatting.c:1620:
> undefined reference to `u_errorName_70'
> /usr/bin/ld: utils/adt/pg_locale.o: in function `init_icu_converter':
> /home/jian/Desktop/pg16_source/postgresql/src/backend/utils/adt/pg_locale.c:1748:
> undefined reference to `ucnv_open_70'
> /usr/bin/ld: utils/adt/pg_locale.o: in function `make_icu_collator':
> /home/jian/Desktop/pg16_source/postgresql/src/backend/utils/adt/pg_locale.c:1399:
> undefined reference to `ucol_open_70'
> /usr/bin/ld: utils/adt/pg_locale.o: in function
> `get_collation_actual_version':
> /home/jian/Desktop/pg16_source/postgresql/src/backend/utils/adt/pg_locale.c:1647:
> undefined reference to `ucol_open_70'
> /usr/bin/ld:
> /home/jian/Desktop/pg16_source/postgresql/src/backend/utils/adt/pg_locale.c:1652:
> undefined reference to `ucol_getVersion_70'
> /usr/bin/ld:
> /home/jian/Desktop/pg16_source/postgresql/src/backend/utils/adt/pg_locale.c:1653:
> undefined reference to `ucol_close_70'
> /usr/bin/ld:
> /home/jian/Desktop/pg16_source/postgresql/src/backend/utils/adt/pg_locale.c:1655:
> undefined reference to `u_versionToString_70'
> /usr/bin/ld: utils/adt/pg_locale.o: in function `icu_to_uchar':
> /home/jian/Desktop/pg16_source/postgresql/src/backend/utils/adt/pg_locale.c:1778:
> undefined reference to `ucnv_toUChars_70'
> /usr/bin/ld:
> /home/jian/Desktop/pg16_source/postgresql/src/backend/utils/adt/pg_locale.c:1787:
> undefined reference to `ucnv_toUChars_70'
> /usr/bin/ld: utils/adt/pg_locale.o: in function `icu_from_uchar':
> /home/jian/Desktop/pg16_source/postgresql/src/backend/utils/adt/pg_locale.c:1816:
> undefined reference to `ucnv_fromUChars_70'
> /usr/bin/ld:
> /home/jian/Desktop/pg16_source/postgresql/src/backend/utils/adt/pg_locale.c:1826:
> undefined reference to `ucnv_fromUChars_70'
> /usr/bin/ld: utils/adt/pg_locale.o: in function `check_icu_locale':
> /home/jian/Desktop/pg16_source/postgresql/src/backend/utils/adt/pg_locale.c:1948:
> undefined reference to `ucol_open_70'
> /usr/bin/ld:
> /home/jian/Desktop/pg16_source/postgresql/src/backend/utils/adt/pg_locale.c:1956:
> undefined reference to `ucol_close_70'
> /usr/bin/ld: utils/adt/pg_locale.o: in function `init_icu_converter':
> /home/jian/Desktop/pg16_source/postgresql/src/backend/utils/adt/pg_locale.c:1750:
> undefined reference to `u_errorName_70'
> /usr/bin/ld: utils/adt/pg_locale.o: in function `make_icu_collator':
> /home/jian/Desktop/pg16_source/postgresql/src/backend/utils/adt/pg_locale.c:1401:
> undefined reference to `u_errorName_70'
> /usr/bin/ld: utils/adt/pg_locale.o: in function
> `get_collation_actual_version':
> /home/jian/Desktop/pg16_source/postgresql/src/backend/utils/adt/pg_locale.c:1649:
> undefined reference to `u_errorName_70'
> /usr/bin/ld: utils/adt/pg_locale.o: in function `icu_to_uchar':
> /home/jian/Desktop/pg16_source/postgresql/src/backend/utils/adt/pg_locale.c:1790:
> undefined reference to `u_errorName_70'
> /usr/bin/ld:
> /home/jian/Desktop/pg16_source/postgresql/src/backend/utils/adt/pg_locale.c:1781:
> undefined reference to `u_errorName_70'
> /usr/bin/ld:
> utils/adt/pg_locale.o:/home/jian/Desktop/pg16_source/postgresql/src/backend/utils/adt/pg_locale.c:1829:
> more undefined references to `u_errorName_70' follow
> /usr/bin/ld: utils/adt/varchar.o: in function `hashbpchar':
> /home/jian/Desktop/pg16_source/postgresql/src/backend/utils/adt/varchar.c:1028:
> undefined reference to `ucol_getSortKey_70'
> /usr/bin/ld:
> /home/jian/Desktop/pg16_source/postgresql/src/backend/utils/adt/varchar.c:1031:
> undefined reference to `ucol_getSortKey_70'
> /usr/bin/ld: utils/adt/varchar.o: in function `hashbpcharextended':
> /home/jian/Desktop/pg16_source/postgresql/src/backend/utils/adt/varchar.c:1089:
> undefined reference to `ucol_getSortKey_70'
> /usr/bin/ld:
> /home/jian/Desktop/pg16_source/postgresql/src/backend/utils/adt/varchar.c:1092:
> undefined reference to `ucol_getSortKey_70'
> /usr/bin/ld: utils/adt/varlena.o: in function `varstr_abbrev_convert':
> /home/jian/Desktop/pg16_source/postgresql/src/backend/utils/adt/varlena.c:2589:
> undefined reference to `ucol_getSortKey_70'
> /usr/bin/ld:
> /home/jian/Desktop/pg16_source/postgresql/src/backend/utils/adt/varlena.c:2574:
> undefined reference to `uiter_setUTF8_70'
> /usr/bin/ld:
> /home/jian/Desktop/pg16_source/postgresql/src/backend/utils/adt/varlena.c:2577:
> undefined reference to `ucol_nextSortKeyPart_70'
> /usr/bin/ld: utils/adt/varlena.o: in function `varstrfastcmp_locale':
> /home/jian/Desktop/pg16_source/postgresql/src/backend/utils/adt/varlena.c:2411:
> undefined reference to `ucol_strcoll_70'
> /usr/bin/ld:
> /home/jian/Desktop/pg16_source/postgresql/src/backend/utils/adt/varlena.c:2392:
> undefined reference to `ucol_strcollUTF8_70'
> /usr/bin/ld: utils/adt/varlena.o: in function `varstr_cmp':
> /home/jian/Desktop/pg16_source/postgresql/src/backend/utils/adt/varlena.c:1688:
> undefined reference to `ucol_strcoll_70'
> /usr/bin/ld:
> /home/jian/Desktop/pg16_source/postgresql/src/backend/utils/adt/varlena.c:1669:
> undefined reference to `ucol_strcollUTF8_70'
> /usr/bin/ld: utils/adt/varlena.o: in function `varstr_abbrev_convert':
> /home/jian/Desktop/pg16_source/postgresql/src/backend/utils/adt/varlena.c:2584:
> undefined reference to `u_errorName_70'
> /usr/bin/ld: utils/adt/varlena.o: in function `varstrfastcmp_locale':
> /home/jian/Desktop/pg16_source/postgresql/src/backend/utils/adt/varlena.c:2397:
> undefined reference to `u_errorName_70'
> /usr/bin/ld: utils/adt/varlena.o: in function `varstr_cmp':
> /home/jian/Desktop/pg16_source/postgresql/src/backend/utils/adt/varlena.c:1674:
> undefined reference to `u_errorName_70'
> collect2: error: ld returned 1 exit status
> make[2]: *** [Makefile:66: postgres] Error 1
> make[2]: Leaving directory
> '/home/jian/Desktop/pg16_source/postgresql/src/backend'
> make[1]: *** [Makefile:42: all-backend-recurse] Error 2
> make[1]: Leaving directory '/home/jian/Desktop/pg16_source/postgresql/src'
> make: *** [GNUmakefile:16: world-src-recurse] Error 2
>

So now postgresql does not support ICU version 71?

On Tue, Aug 2, 2022 at 8:08 PM jian he <jian(dot)universality(at)gmail(dot)com> wrote:

>
> Install from source code(follow the manual)
> system version: Ubuntu 22.04 LTS
> pg version: PostgreSQL 15beta2 on x86_64-pc-linux-gnu, compiled by gcc
> (Ubuntu 11.2.0-19ubuntu1) 11.2.0, 64-bit
>
> install step:
>
>> ./configure --with-perl --with-python --with-icu
>> ICU_CFLAGS='-I/usr/include/unicode' ICU_LIBS='-L/usr/lib/icu'
>> --enable-debug --with-pgport=5439
>>
> make world
>> sudo su
>> make install world
>> mkdir -p /usr/local/pgsql/data
>> chown jian /usr/local/pgsql/data
>> su - jian
>> /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
>> /usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data -l logfile start
>> /usr/local/pgsql/bin/createdb test
>> /usr/local/pgsql/bin/psql test
>>
>
> I installed ICU4C 71.1package.
> use /usr/bin/icuinfo return
>
>> <icuSystemParams type="icu4c">
>> <param name="copyright"> Copyright (C) 2016 and later: Unicode, Inc.
>> and others. License & terms of use: http://www.unicode.org/copyright.html
>> </param>
>> <param name="product">icu4c</param>
>> <param name="product.full">International Components for Unicode for
>> C/C++</param>
>> <param name="version">71.1</param>
>> <param name="version.unicode">14.0</param>
>> <param name="platform.number">4000</param>
>> <param name="platform.type">Linux</param>
>> <param name="locale.default">en_US</param>
>> <param name="locale.default.bcp47">en-US</param>
>> <param name="converter.default">UTF-8</param>
>> <param name="icudata.name">icudt71l</param>
>> <param name="icudata.path"></param>
>> <param name="cldr.version">41.0</param>
>> <param name="tz.version">2022a</param>
>> <param name="tz.default">Asia/Kolkata</param>
>> <param name="cpu.bits">64</param>
>> <param name="cpu.big_endian">0</param>
>> <param name="os.wchar_width">4</param>
>> <param name="os.charset_family">0</param>
>> <param name="os.host">x86_64-pc-linux-gnu</param>
>> <param name="build.build">x86_64-pc-linux-gnu</param>
>> <param name="build.cc">gcc</param>
>> <param name="build.cxx">g++</param>
>> <param name="uconfig.internal_digitlist">1</param>
>> <param name="uconfig.have_parseallinput">1</param>
>> </icuSystemParams>
>>
>>
>> ICU Initialization returned: U_ZERO_ERROR
>
> Plugins are disabled.
>>
>
> But now I cannot ICU. when I create an collation related to ICU then
>
>> ERROR: ICU is not supported in this build
>>
>
>
> --
> I recommend David Deutsch's <<The Beginning of Infinity>>
>
> Jian
>
>
>

--
I recommend David Deutsch's <<The Beginning of Infinity>>

Jian

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message PG Bug reporting form 2022-08-03 10:09:07 BUG #17567: Unable to Set Max_Connection in Postgresql which has replicas
Previous Message Thomas Munro 2022-08-03 02:49:14 Re: Strange collation names ("hu_HU.UTF-8")