Обсуждение: 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}@${HOST%%.*}: ${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
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@postgresql.org [mailto:pgsql-ports-owner@postgresql.org] On Behalf Of dev@volpe.it
Sent: Thursday, May 26, 2005 1:15 PM
To: pgsql-ports@postgresql.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}@${HOST%%.*}: ${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
Hi!
I had success on AIX 5.1 ML8 on a little and old 7043-140
XLC 6 etc...
using this options:
./configure CC=/usr/vac/bin/cc --with-includes=/opt/freeware/include
--with-libraries=/opt/freeware/lib --with-python --with-perl --with-
pam --enable-thread-safety
On 5.3 I can build but PERL and -thread-safety are mutually
exclusive. But is not a real problem, because any way on 5.3 it wont
run after build...;)
Ciao
On May 26, 2005, at 7:31 PM, Mohan, Ross wrote:
> 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@postgresql.org [mailto:pgsql-ports-
> owner@postgresql.org] On Behalf Of dev@volpe.it
> Sent: Thursday, May 26, 2005 1:15 PM
> To: pgsql-ports@postgresql.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}@${HOST%%.*}: ${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
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>
>
>