Re: AIX5.3 & 8.0.3 Problem Summary

Vince,

Yea, it's exhausting. I broke a completely functioning
AIX5.3 64bit -O5 install by simply trying to add readline.
The db might be great for prime time, but the build for anything
but Solaris and Linux sure isn't. God help me if I need to maintain
this. Oh, wait: I do need to maintain it. ;-p

Some things that worked for me:

explicitly setting INCLUDES (sometimes in CPPFLAGS, sometimes in CFLAGS)
explicitly setting LIBRARIES (sometimes in CFLAGS, sometimes in LDFLAGS)
doing w/o zlib
(sorry never experimented w/thread-safety)

But it's far, far more obscure and fragile than it could be, one thinks.
<sigh>

Im boca al lupo,

-- Ross

-----Original Message-----
From: pgsql-ports-owner(at)postgresql(dot)org [mailto:pgsql-ports-owner(at)postgresql(dot)org] On Behalf Of dev(at)volpe(dot)it
Sent: Thursday, May 26, 2005 1:15 PM
To: pgsql-ports(at)postgresql(dot)org
Subject: [PORTS] AIX5.3 & 8.0.3 Problem Summary

It seems I'm having all the problems in the list at once!

I'm compiling using the following environment but I have the same
problems on a 7043-140 AIX 5.1 ML8:
Pseries 9117-570
oslevel -r
5300-02
4 processors 1.65 Ghz
8 GB RAM

_=/usr/bin/env PATH=/usr/bin:/etc:/usr/sbin:/usr/ucb:/usr/dt/bin:/root/bin:/usr/bin/
X11:/usr/java14/jre/bin:/usr/java14/bin:/sbin:/usr/java14_64/jre/bin:/
usr/local/bin:/usr/vac/bin:/usr/local/pgsql/bin:/opt/freeware/bin
EDITOR=vi
LOGNAME=root
MAIL=/usr/spool/mail/root
PS1=${LOGNAME}(at)${HOST%%(dot)*}: ${PWD} #
USER=root
SHELL=/usr/bin/ksh
HOME=/root
TERM=dtterm
MAILMSG=[YOU HAVE NEW MAIL]
PWD=/Inst/postgresql-8.0.3
ENV=/root/.env
A__z=! LOGNAME LIBPATH=/usr/lib:/opt/freeware/lib:/lib:/usr/lib/threads:usr/local/
pgsql/lib

./configure CC=/usr/vac/bin/cc --enable-aix64 --with-includes=/opt/
freeware/include --with-libraries=/opt/freeware/lib --with-python --
with-pam --enable-thread-safety
OK
gmake
OK
gmake install
OK
/usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
OK
/usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data -l logfile start OK createdb test
createdb: could not connect to database template1: FATAL:
unsupported frontend protocol 0.0: server supports 1.0 to 3.0

And for this we are waiting for IBM ...

---------------------------------------------
*********************************************

BUT going to use O5 or both PERL and thread-safe it fail... as follow:

./configure CC=/usr/vac/bin/cc --enable-aix64 --with-includes=/opt/
freeware/include --with-libraries=/opt/freeware/lib --with-python --
with-perl --with-pam --enable-thread-safety
OK
gmake
NO

gmake[4]: Entering directory `/Inst/postgresql-8.0.3/src/pl/plpgsql/src'
/usr/vac/bin/cc -O2 -qmaxmem=16384 -qsrcmsg -qlonglong -I. -
I../../../../src/include -I/opt/freeware/include -c -o pl_gram.o
pl_gram.c
/usr/vac/bin/cc -O2 -qmaxmem=16384 -qsrcmsg -qlonglong -I. -
I../../../../src/include -I/opt/freeware/include -c -o pl_handler.o
pl_handler.c
/usr/vac/bin/cc -O2 -qmaxmem=16384 -qsrcmsg -qlonglong -I. -
I../../../../src/include -I/opt/freeware/include -c -o pl_comp.o
pl_comp.c
/usr/vac/bin/cc -O2 -qmaxmem=16384 -qsrcmsg -qlonglong -I. -
I../../../../src/include -I/opt/freeware/include -c -o pl_exec.o
pl_exec.c
/usr/vac/bin/cc -O2 -qmaxmem=16384 -qsrcmsg -qlonglong -I. -
I../../../../src/include -I/opt/freeware/include -c -o pl_funcs.o
pl_funcs.c
ar crs libplpgsql.a pl_gram.o pl_handler.o pl_comp.o pl_exec.o
pl_funcs.o
touch libplpgsql.a ../../../../src/backend/port/aix/mkldexport.sh libplpgsql.a >
libplpgsql.exp
/usr/vac/bin/cc -O2 -qmaxmem=16384 -qsrcmsg -qlonglong -Wl,-bnoentry
-Wl,-H512 -Wl,-bM:SRE -o libplpgsql.so libplpgsql.a -L../../../../src/
port -L/opt/freeware/lib -L../../../../src/port -L/opt/freeware/
lib -Wl,-bI:../../../../src/backend/postgres.imp -Wl,-
bE:libplpgsql.exp
gmake[4]: Leaving directory `/Inst/postgresql-8.0.3/src/pl/plpgsql/src'
gmake[3]: Leaving directory `/Inst/postgresql-8.0.3/src/pl/plpgsql'
gmake[3]: Entering directory `/Inst/postgresql-8.0.3/src/pl/plperl'
/usr/vac/bin/cc -O2 -qmaxmem=16384 -qsrcmsg -qlonglong -I. -
I../../../src/include -I/opt/freeware/include -I/usr/opt/perl5/lib/
5.8.2/aix-thread-multi/CORE -c -o plperl.o plperl.c "/usr/opt/perl5/lib/5.8.2/aix-thread-multi/CORE/reentr.h", line
619.16: 1506-007 (S) "struct drand48_data" is undefined. "/usr/opt/perl5/lib/5.8.2/aix-thread-multi/CORE/reentr.h", line
727.16: 1506-007 (S) "struct random_data" is undefined. "/usr/opt/perl5/lib/5.8.2/aix-thread-multi/CORE/reentr.h", line
775.16: 1506-007 (S) "struct random_data" is undefined.
gmake[3]: *** [plperl.o] Error 1
gmake[3]: Leaving directory `/Inst/postgresql-8.0.3/src/pl/plperl'
gmake[2]: *** [all] Error 2
gmake[2]: Leaving directory `/Inst/postgresql-8.0.3/src/pl'
gmake[1]: *** [all] Error 2
gmake[1]: Leaving directory `/Inst/postgresql-8.0.3/src'
gmake: *** [all] Error 2

Ciao

Vince

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq