Re: Problem compiling PostgreSQL.

[Daniel Verite]

Paul Linehan wrote:

> Now, I've installed the icu libraries using the classic ./configure, make
> and sudo make install.

So it got installed under /usr/local

> collationcmds.c:(.text+0xe36): undefined reference to `uloc_getAvailable_61'
> collationcmds.c:(.text+0xe5b): undefined reference to
> `uloc_toLanguageTag_61'

61 is ICU's major version number.
You have two ICU versions installed, one from Fedora, with
its icu*.pc config files located in usr/lib64/pkgconfig, the other
(presumably v61, as it's the latest) in /usr/local/lib/pkgconfig/
Without specifying which one should be used, it looks like
Postgres get them mixed between compilation and link.

To use self-compiled ICU, I've been having success
configuring postgres with:

PKG_CONFIG_PATH=/path/to/icu/lib/pkgconfig \
./configure --with-icu [other flags]

I tend to install ICUs versions into their own directories rather
than /usr/local, and use Debian rather than Fedora, but you
might try PKG_CONFIG_PATH=/usr/local/lib/pkgconfig


Best regards,
-- 
Daniel Vérité
PostgreSQL-powered mailer: http://www.manitou-mail.org
Twitter: @DanielVerite

Re: Problem compiling PostgreSQL.

[Paul Linehan]

Hi again,


As a followup - I ran this command  (do I need to set LD_LIBRARY_PATH?)

[pol@polhost /]$ sudo find . -name "icu*" | grep -v Downloads |  more


And got:


./usr/local/sbin/icupkg
./usr/local/bin/icuinfo
./usr/local/bin/icu-config
./usr/local/lib/icu
./usr/local/lib/pkgconfig/icu-io.pc
./usr/local/lib/pkgconfig/icu-uc.pc
./usr/local/lib/pkgconfig/icu-i18n.pc
./usr/local/share/icu
./usr/local/share/man/man8/icupkg.8
./usr/local/share/man/man1/icu-config.1
./usr/local/include/unicode/icuplug.h
./usr/local/include/unicode/icudataver.h
./usr/bin/icuinfo
./usr/bin/icu-config-64
./usr/bin/icu-config
./usr/lib64/icu
./usr/lib64/pkgconfig/icu-io.pc
./usr/lib64/pkgconfig/icu-uc.pc
./usr/lib64/pkgconfig/icu-i18n.pc
./usr/lib/jvm/java-10-openjdk-10.0.1.10-3.fc28.x86_64/legal/java.base/icu.md
./usr/share/maven-metadata/icu4j.xml
./usr/share/icu
./usr/share/licenses/icu4j
./usr/share/jython/javalib/icu4j_icu4j.jar
./usr/share/maven-poms/icu4j
./usr/share/maven-poms/icu4j/icu4j.pom
./usr/share/java/icu4j
./usr/share/java/icu4j/icu4j.jar
./usr/share/doc/icu4j
./usr/share/man/man1/icu-config.1.gz
./usr/share/man/man1/icuinfo.1.gz
./usr/include/boost/regex/icu.hpp
./usr/include/unicode/icuplug.h
./usr/include/unicode/icudataver.h
[pol@polhost /]$

It seems that the library was installed, but the PostgreSQL make
command can't "see" the libs?

Re: Problem compiling PostgreSQL.

[Paul Linehan]

>> On which platform and/or distribution are you trying the code
>> compilation?

> sorry about that - it's Linux Fedora 28, 64 bit Intel X86_64 - Samsung
> laptop, 8GB RAM, quad-core.

PostgreSQL 10.4 also.


Pól...

Re: Problem compiling PostgreSQL.

[Paul Linehan]

Hi, and thanks for responding,


>> I'm having problems compiling PostgreSQL.

> On which platform and/or distribution are you trying the code
> compilation?


Ooops!

sorry about that - it's Linux Fedora 28, 64 bit Intel X86_64 - Samsung
laptop, 8GB RAM, quad-core.


Please don't hesitate to ask should you require further information!

Rgs,


Pól...

Re: Problem compiling PostgreSQL.

[Michael Paquier]

On Thu, May 17, 2018 at 08:31:48AM +0100, Paul Linehan wrote:
> I'm having problems compiling PostgreSQL.

On which platform and/or distribution are you trying the code
compilation?
--
Michael


signature.asc
Description: PGP signature

Problem compiling PostgreSQL.

[Paul Linehan]

Hi all,

I'm having problems compiling PostgreSQL.

I can run "make" no problem with this command

./configure --prefix=/home/pol/Downloads/sware/db/pg/inst
--mandir=/home/pol/Downloads/sware/db/pg/inst/man
--docdir=/home/pol/Downloads/sware/db/pg/inst/doc --enable-nls
--with-python --with-openssl --with-systemd --with-uuid=e2fs --with-libxml
--with-libxslt

but not this one

./configure --prefix=/home/pol/Downloads/sware/db/pg/inst
--mandir=/home/pol/Downloads/sware/db/pg/inst/man
--docdir=/home/pol/Downloads/sware/db/pg/inst/doc --enable-nls
--with-python --with-icu --with-openssl --with-systemd --with-uuid=e2fs
--with-libxml --with-libxslt

(for those of you with bad eyesight, the difference is in the extra
"--with-icu" in the second failing command! :-) )


Now, I've installed the icu libraries using the classic ./configure, make
and sudo make install.

The error I'm getting is

make[4]: Leaving directory '/home/pol/Downloads/sware/db/pg/src/src/port'
make -C ../../src/common all
make[4]: Entering directory '/home/pol/Downloads/sware/db/pg/src/src/common'
make -C ../backend submake-errcodes
make[5]: Entering directory
'/home/pol/Downloads/sware/db/pg/src/src/backend'
make[5]: Nothing to be done for 'submake-errcodes'.
make[5]: Leaving directory '/home/pol/Downloads/sware/db/pg/src/src/backend'
make[4]: Leaving directory '/home/pol/Downloads/sware/db/pg/src/src/common'
make[3]: Leaving directory
'/home/pol/Downloads/sware/db/pg/src/src/timezone'
/usr/bin/gcc -Wall -Wmissing-prototypes -Wpointer-arith
-Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute
-Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard
-O2 -L../../src/port -L../../src/common -Wl,--as-needed
-Wl,-rpath,'/home/pol/Downloads/sware/db/pg/inst/lib',--enable-new-dtags
-Wl,-E access/brin/brin.o access/brin/brin_pageops.o

... a shedload more .o files snipped from error and then at the end:

../../src/timezone/pgtz.o ../../src/port/libpgport_srv.a
../../src/common/libpgcommon_srv.a -lpthread -lxslt -lxml2 -lssl -lcrypto
-lrt -lcrypt -ldl -lm -licui18n -licuuc -licudata -lsystemd -o postgres
commands/collationcmds.o: In function `pg_import_system_collations':
collationcmds.c:(.text+0xe16): undefined reference to
`uloc_countAvailable_61'
collationcmds.c:(.text+0xe36): undefined reference to `uloc_getAvailable_61'
collationcmds.c:(.text+0xe5b): undefined reference to
`uloc_toLanguageTag_61'
collationcmds.c:(.text+0xf0c): undefined reference to
`uloc_countAvailable_61'
collationcmds.c:(.text+0xf85): undefined reference to
`uloc_getDisplayName_61'
collationcmds.c:(.text+0x112e): undefined reference to `u_errorName_61'
regex/regcomp.o: In function `pg_wc_isalpha':
regcomp.c:(.text+0x9a1): undefined reference to `u_isalpha_61'  <--- seems
to be an icu issue here?
regex/regcomp.o: In function `pg_wc_isspace':
regcomp.c:(.text+0xa81): undefined reference to `u_isspace_61'


... snip a lot more undefined reference errors with u__61 in them

and then at the end

varlena.c:(.text+0x2245): undefined reference to `ucol_strcoll_61'
varlena.c:(.text+0x2292): undefined reference to `ucol_strcollUTF8_61'
varlena.c:(.text+0x22c3): undefined reference to `u_errorName_61'
collect2: error: ld returned 1 exit status
make[2]: *** [Makefile:61: postgres] Error 1
make[2]: Leaving directory '/home/pol/Downloads/sware/db/pg/src/src/backend'
make[1]: *** [Makefile:38: all-backend-recurse] Error 2
make[1]: Leaving directory '/home/pol/Downloads/sware/db/pg/src/src'
make: *** [GNUmakefile:11: all-src-recurse] Error 2
[pol@polhost src]$


I've compiled PostgreSQL many times and I've always been impressed with the
way it "just works"!

I would be grateful if anybody could show me how I could resolve my issue.

TIA, Pól...

Re: Problem with postgreSQL

[Adrian Klaver]

On 03/28/2018 02:36 AM, Gian mario Caggiu wrote:
Please also reply to list so this can be seen by more eyes.
Ccing list

I've already written to you what versions I downloaded, 10.3 and 9.6.8. 
I clicked in the 'download the installer' section and then I selected 
the version to download.


So this section, correct?:
"
Interactive installer by EnterpriseDB

Download the installer certified by EnterpriseDB for all supported 
PostgreSQL versions.

"


For reference, what version of OS X?

After downloading the installer you ran the GUI installer, correct?

Where there any errors when you ran the installation process?




FYI, there are other choices on this page:

https://www.postgresql.org/download/macosx/

One that may be easier to deal with at this stage is:

Postgres.app

Postgres.app is a simple, native macOS app that runs in the menubar 
without the need of an installer. Open the app, and you have a 
PostgreSQL server ready and awaiting new connections. Close the app, and 
the server shuts down.



http://postgresapp.com/





Il giorno 27 mar 2018, alle ore 20:44, Adrian Klaver 
> ha scritto:


Which of the downloads did you select from below?:

https://www.postgresql.org/download/macosx/

Without that information it is not possible to provide an answer.





--
Adrian Klaver
adrian.kla...@aklaver.com

Re: Problem with postgreSQL

[Adrian Klaver]

On 03/27/2018 11:39 AM, Gian mario Caggiu wrote:


I downloaded two versions, 9.6.8 and 10.3, but both did not work. I 
followed the instructions on the website and in the page where I have to 
choose the version and the operating system I chose the two versions 
that I have already told you. then the installation of the program did 
not finish displaying a message with 'the database cluster 
initialization failed postgresql mac os'


Which of the downloads did you select from below?:

https://www.postgresql.org/download/macosx/

Without that information it is not possible to provide an answer.



Il giorno 27 mar 2018, alle ore 18:01, Adrian Klaver 
> ha scritto:


On 03/27/2018 07:18 AM, Gian mario Caggiu wrote:
Please reply to list also.
Ccing list.


I downloaded the first time 9.6 version, and when i saw that it 
doesn’t work i downloaded an other version, 10.3, but Also this 
doesn’t work. All downloads fromhttp://www.postgresql.org 
.

And i install it how the website advised me.


There are six choices for Mac:

https://www.postgresql.org/download/macosx/

You will need to be more specific on which option you chose.

Also what Web site are you referring to when talking about install 
instructions?


When you say did not work, can you be more specific, with error 
messages if possible?




Gian Mario Caggiu
Il giorno 27 mar 2018, alle ore 06:03, Adrian Klaver 
> ha 
scritto:



On 03/26/2018 04:41 AM, Gian mario Caggiu wrote:
Hi, I'm a student and I downloaded postgreSQL to my Mac but I found 
a problem. The program does not start, I do not understand why, but 
that's


Where did you download it from?

What version of Postgres?

How did you install it?

not what scares me. The fact is that a virtual user has been 
created called 'postgreSQL' which has appropriated all the 
functions of the administrator user. Can I kindly ask you why and 
how did this happen?

Gian Mario Caggiu



--
Adrian Klaver
adrian.kla...@aklaver.com 



--
Adrian Klaver
adrian.kla...@aklaver.com 





--
Adrian Klaver
adrian.kla...@aklaver.com

Re: Problem with postgreSQL

[Adrian Klaver]

On 03/27/2018 07:18 AM, Gian mario Caggiu wrote:
Please reply to list also.
Ccing list.



I downloaded the first time 9.6 version, and when i saw that it doesn’t work i 
downloaded an other version, 10.3, but Also this doesn’t work. All downloads 
from http://www.postgresql.org .
And i install it how the website advised me.


There are six choices for Mac:

https://www.postgresql.org/download/macosx/

You will need to be more specific on which option you chose.

Also what Web site are you referring to when talking about install 
instructions?


When you say did not work, can you be more specific, with error messages 
if possible?





Gian Mario Caggiu


Il giorno 27 mar 2018, alle ore 06:03, Adrian Klaver 
 ha scritto:


On 03/26/2018 04:41 AM, Gian mario Caggiu wrote:
Hi, I'm a student and I downloaded postgreSQL to my Mac but I found a problem. 
The program does not start, I do not understand why, but that's


Where did you download it from?

What version of Postgres?

How did you install it?


not what scares me. The fact is that a virtual user has been created called 
'postgreSQL' which has appropriated all the functions of the administrator 
user. Can I kindly ask you why and how did this happen?
Gian Mario Caggiu



--
Adrian Klaver
adrian.kla...@aklaver.com



--
Adrian Klaver
adrian.kla...@aklaver.com

Re: Problem with postgreSQL

[Adrian Klaver]

On 03/26/2018 04:41 AM, Gian mario Caggiu wrote:
Hi, I'm a student and I downloaded postgreSQL to my Mac but I found a 
problem. The program does not start, I do not understand why, but that's 


Where did you download it from?

What version of Postgres?

How did you install it?

not what scares me. The fact is that a virtual user has been created 
called 'postgreSQL' which has appropriated all the functions of the 
administrator user. Can I kindly ask you why and how did this happen?



Gian Mario Caggiu



--
Adrian Klaver
adrian.kla...@aklaver.com