Re: postgresql 7.2 on AIX 5.1

Hello all,

Does someone run PostgreSQL 7.2 on AIX 5.1?
I tries to compile it but I encounter error:

./configure --with-CC=gcc

ld: 0711-317 ERROR: Undefined symbol:.ceil
ld: 0711-317 ERROR: Undefined symbol:: .log
ld: 0711-317 ERROR: Undefined symbol:: .sqrt
ld: 0711-317 ERROR: Undefined symbol:: .isnan
ld: 0711-317 ERROR: Undefined symbol:: .floor
ld: 0711-317 ERROR: Undefined symbol: .pow
ld: 0711-317 ERROR: Undefined symbol:: .exp
ld: 0711-317 ERROR: Undefined symbol:: .log10
ld: 0711-317 ERROR: Undefined symbol:: .acos
ld: 0711-317 ERROR: Undefined symbol:: .asin
ld: 0711-317 ERROR: Undefined symbol:: .atan
ld: 0711-317 ERROR: Undefined symbol:: .atan2
ld: 0711-317 ERROR: Undefined symbol:: .cos
ld: 0711-317 ERROR: Undefined symbol:: .tan
ld: 0711-317 ERROR: Undefined symbol:: .sin

Please let me know if you have some idea.

Thanks.

Daiju Kato
e-mail: dkato(at)luna(dot)email(dot)ne(dot)jp

Looks like it is missing -lm on the link line. What is it testing at
that point? We have many successful AIX users.

---------------------------------------------------------------------------

Daiju Kato wrote:
> Hello all,
>
> Does someone run PostgreSQL 7.2 on AIX 5.1?
> I tries to compile it but I encounter error:
>
> ./configure --with-CC=gcc
>
> ld: 0711-317 ERROR: Undefined symbol:.ceil
> ld: 0711-317 ERROR: Undefined symbol:: .log
> ld: 0711-317 ERROR: Undefined symbol:: .sqrt
> ld: 0711-317 ERROR: Undefined symbol:: .isnan
> ld: 0711-317 ERROR: Undefined symbol:: .floor
> ld: 0711-317 ERROR: Undefined symbol: .pow
> ld: 0711-317 ERROR: Undefined symbol:: .exp
> ld: 0711-317 ERROR: Undefined symbol:: .log10
> ld: 0711-317 ERROR: Undefined symbol:: .acos
> ld: 0711-317 ERROR: Undefined symbol:: .asin
> ld: 0711-317 ERROR: Undefined symbol:: .atan
> ld: 0711-317 ERROR: Undefined symbol:: .atan2
> ld: 0711-317 ERROR: Undefined symbol:: .cos
> ld: 0711-317 ERROR: Undefined symbol:: .tan
> ld: 0711-317 ERROR: Undefined symbol:: .sin
>
> Please let me know if you have some idea.
>
> Thanks.
>
>
> Daiju Kato
> e-mail: dkato(at)luna(dot)email(dot)ne(dot)jp
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

Hi Bruce,

Thanks, reply.
Please tell me how to -lm with configure.

Thanks.

Daiju

"Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us> wrote in message
news:200208021912(dot)g72JCHK13272(at)candle(dot)pha(dot)pa(dot)us(dot)(dot)(dot)
>
> Looks like it is missing -lm on the link line. What is it testing at
> that point? We have many successful AIX users.
>
> --------------------------------------------------------------------------
-
>
> Daiju Kato wrote:
> > Hello all,
> >
> > Does someone run PostgreSQL 7.2 on AIX 5.1?
> > I tries to compile it but I encounter error:
> >
> > ./configure --with-CC=gcc
> >
> > ld: 0711-317 ERROR: Undefined symbol:.ceil
> > ld: 0711-317 ERROR: Undefined symbol:: .log
> > ld: 0711-317 ERROR: Undefined symbol:: .sqrt
> > ld: 0711-317 ERROR: Undefined symbol:: .isnan
> > ld: 0711-317 ERROR: Undefined symbol:: .floor
> > ld: 0711-317 ERROR: Undefined symbol: .pow
> > ld: 0711-317 ERROR: Undefined symbol:: .exp
> > ld: 0711-317 ERROR: Undefined symbol:: .log10
> > ld: 0711-317 ERROR: Undefined symbol:: .acos
> > ld: 0711-317 ERROR: Undefined symbol:: .asin
> > ld: 0711-317 ERROR: Undefined symbol:: .atan
> > ld: 0711-317 ERROR: Undefined symbol:: .atan2
> > ld: 0711-317 ERROR: Undefined symbol:: .cos
> > ld: 0711-317 ERROR: Undefined symbol:: .tan
> > ld: 0711-317 ERROR: Undefined symbol:: .sin
> >
> > Please let me know if you have some idea.
> >
> > Thanks.
> >
> >
> > Daiju Kato
> > e-mail: dkato(at)luna(dot)email(dot)ne(dot)jp
> >
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 6: Have you searched our list archives?
> >
> > http://archives.postgresql.org
> >
>
> --
> Bruce Momjian | http://candle.pha.pa.us
> pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
> + If your life is a hard drive, | 830 Blythe Avenue
> + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly

I need to see more of your configure error lines just before the error
so I know what it is trying to link. You can also do 'set -x' in
configure to see what it is trying.

---------------------------------------------------------------------------

Daiju Kato wrote:
> Hi Bruce,
>
> Thanks, reply.
> Please tell me how to -lm with configure.
>
> Thanks.
>
> Daiju
>
> "Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us> wrote in message
> news:200208021912(dot)g72JCHK13272(at)candle(dot)pha(dot)pa(dot)us(dot)(dot)(dot)
> >
> > Looks like it is missing -lm on the link line. What is it testing at
> > that point? We have many successful AIX users.
> >
> > --------------------------------------------------------------------------
> -
> >
> > Daiju Kato wrote:
> > > Hello all,
> > >
> > > Does someone run PostgreSQL 7.2 on AIX 5.1?
> > > I tries to compile it but I encounter error:
> > >
> > > ./configure --with-CC=gcc
> > >
> > > ld: 0711-317 ERROR: Undefined symbol:.ceil
> > > ld: 0711-317 ERROR: Undefined symbol:: .log
> > > ld: 0711-317 ERROR: Undefined symbol:: .sqrt
> > > ld: 0711-317 ERROR: Undefined symbol:: .isnan
> > > ld: 0711-317 ERROR: Undefined symbol:: .floor
> > > ld: 0711-317 ERROR: Undefined symbol: .pow
> > > ld: 0711-317 ERROR: Undefined symbol:: .exp
> > > ld: 0711-317 ERROR: Undefined symbol:: .log10
> > > ld: 0711-317 ERROR: Undefined symbol:: .acos
> > > ld: 0711-317 ERROR: Undefined symbol:: .asin
> > > ld: 0711-317 ERROR: Undefined symbol:: .atan
> > > ld: 0711-317 ERROR: Undefined symbol:: .atan2
> > > ld: 0711-317 ERROR: Undefined symbol:: .cos
> > > ld: 0711-317 ERROR: Undefined symbol:: .tan
> > > ld: 0711-317 ERROR: Undefined symbol:: .sin
> > >
> > > Please let me know if you have some idea.
> > >
> > > Thanks.
> > >
> > >
> > > Daiju Kato
> > > e-mail: dkato(at)luna(dot)email(dot)ne(dot)jp
> > >
> > >
> > >
> > > ---------------------------(end of broadcast)---------------------------
> > > TIP 6: Have you searched our list archives?
> > >
> > > http://archives.postgresql.org
> > >
> >
> > --
> > Bruce Momjian | http://candle.pha.pa.us
> > pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
> > + If your life is a hard drive, | 830 Blythe Avenue
> > + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 3: if posting/reading through Usenet, please send an appropriate
> > subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> > message can get through to the mailing list cleanly
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

Hello Bruce,

Below is error point and how I set configuration on AIX 5.1.
I would appreciate your help.

$export PATH=/usr/local/bin:$PATH
$./configure --with-CC=gcc

make[4]: `SUBSYS.o' is up to date.
gmake[4]: Leaving directory
`/home/dkato/postgresql-7.2.1/src/backend/utils/time
'
gmake[3]: Leaving directory `/home/dkato/postgresql-7.2.1/src/backend/utils'
gcc -O2 -pipe -Wall -Wmissing-prototypes -Wmissing-declarations
access/SUBSYS
.o bootstrap/SUBSYS.o catalog/SUBSYS.o parser/SUBSYS.o commands/SUBSYS.o
executo
r/SUBSYS.o lib/SUBSYS.o libpq/SUBSYS.o main/SUBSYS.o nodes/SUBSYS.o
optimizer/SU
BSYS.o port/SUBSYS.o postmaster/SUBSYS.o regex/SUBSYS.o rewrite/SUBSYS.o
storage
/SUBSYS.o tcop/SUBSYS.o utils/SUBSYS.o -lPW -lld -lnsl -ldl -o postgres
ld: 0711-317 ERROR: Undefined symbol: .ceil
ld: 0711-317 ERROR: Undefined symbol: .log
ld: 0711-317 ERROR: Undefined symbol: .sqrt
ld: 0711-317 ERROR: Undefined symbol: .isnan
ld: 0711-317 ERROR: Undefined symbol: .floor
ld: 0711-317 ERROR: Undefined symbol: .pow
ld: 0711-317 ERROR: Undefined symbol: .exp
ld: 0711-317 ERROR: Undefined symbol: .log10
ld: 0711-317 ERROR: Undefined symbol: .acos
ld: 0711-317 ERROR: Undefined symbol: .asin
ld: 0711-317 ERROR: Undefined symbol: .atan
ld: 0711-317 ERROR: Undefined symbol: .atan2
ld: 0711-317 ERROR: Undefined symbol: .cos
ld: 0711-317 ERROR: Undefined symbol: .tan
ld: 0711-317 ERROR: Undefined symbol: .sin
ld: 0711-345 Use the -bloadmap or -bnoquiet option to obtain more
information.
collect2: ld returned 8 exit status
gmake[2]: *** [postgres] Error 1
gmake[2]: Leaving directory `/home/dkato/postgresql-7.2.1/src/backend'
gmake[1]: *** [all] Error 2
gmake[1]: Leaving directory `/home/dkato/postgresql-7.2.1/src'
gmake: *** [all] Error 2
make: The error code from the last command is 2.

Daiju Kato
e-mail:dkato(at)luna(dot)email(dot)ne(dot)jp

"Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us> wrote in message
news:200208031540(dot)g73FeWd02749(at)candle(dot)pha(dot)pa(dot)us(dot)(dot)(dot)
>
> I need to see more of your configure error lines just before the error
> so I know what it is trying to link. You can also do 'set -x' in
> configure to see what it is trying.
>

OK, you are getting a failure on the man postgres link line. I know if
you add -lm after the -ldl, it will link properly. You may be able to
edit makefiles/Makefile.aix or just edit Makefile in backend to do the
same thing. Not sure why it is failing. We should be automatic on all
AIX's. I guess not on AIX 5.1. Tatsuo is our AIX expert. I will CC
him.

---------------------------------------------------------------------------

Daiju Kato wrote:
> Hello Bruce,
>
> Below is error point and how I set configuration on AIX 5.1.
> I would appreciate your help.
>
>
> $export PATH=/usr/local/bin:$PATH
> $./configure --with-CC=gcc
>
> make[4]: `SUBSYS.o' is up to date.
> gmake[4]: Leaving directory
> `/home/dkato/postgresql-7.2.1/src/backend/utils/time
> '
> gmake[3]: Leaving directory `/home/dkato/postgresql-7.2.1/src/backend/utils'
> gcc -O2 -pipe -Wall -Wmissing-prototypes -Wmissing-declarations
> access/SUBSYS
> .o bootstrap/SUBSYS.o catalog/SUBSYS.o parser/SUBSYS.o commands/SUBSYS.o
> executo
> r/SUBSYS.o lib/SUBSYS.o libpq/SUBSYS.o main/SUBSYS.o nodes/SUBSYS.o
> optimizer/SU
> BSYS.o port/SUBSYS.o postmaster/SUBSYS.o regex/SUBSYS.o rewrite/SUBSYS.o
> storage
> /SUBSYS.o tcop/SUBSYS.o utils/SUBSYS.o -lPW -lld -lnsl -ldl -o postgres
> ld: 0711-317 ERROR: Undefined symbol: .ceil
> ld: 0711-317 ERROR: Undefined symbol: .log
> ld: 0711-317 ERROR: Undefined symbol: .sqrt
> ld: 0711-317 ERROR: Undefined symbol: .isnan
> ld: 0711-317 ERROR: Undefined symbol: .floor
> ld: 0711-317 ERROR: Undefined symbol: .pow
> ld: 0711-317 ERROR: Undefined symbol: .exp
> ld: 0711-317 ERROR: Undefined symbol: .log10
> ld: 0711-317 ERROR: Undefined symbol: .acos
> ld: 0711-317 ERROR: Undefined symbol: .asin
> ld: 0711-317 ERROR: Undefined symbol: .atan
> ld: 0711-317 ERROR: Undefined symbol: .atan2
> ld: 0711-317 ERROR: Undefined symbol: .cos
> ld: 0711-317 ERROR: Undefined symbol: .tan
> ld: 0711-317 ERROR: Undefined symbol: .sin
> ld: 0711-345 Use the -bloadmap or -bnoquiet option to obtain more
> information.
> collect2: ld returned 8 exit status
> gmake[2]: *** [postgres] Error 1
> gmake[2]: Leaving directory `/home/dkato/postgresql-7.2.1/src/backend'
> gmake[1]: *** [all] Error 2
> gmake[1]: Leaving directory `/home/dkato/postgresql-7.2.1/src'
> gmake: *** [all] Error 2
> make: The error code from the last command is 2.
>
> Daiju Kato
> e-mail:dkato(at)luna(dot)email(dot)ne(dot)jp
>
>
> "Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us> wrote in message
> news:200208031540(dot)g73FeWd02749(at)candle(dot)pha(dot)pa(dot)us(dot)(dot)(dot)
> >
> > I need to see more of your configure error lines just before the error
> > so I know what it is trying to link. You can also do 'set -x' in
> > configure to see what it is trying.
> >
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

Thanks, Bruce.

I success building after below setting.

a) install bos.adt.libm
b)add -lm at LIBS setting in src/Makefile.global.

Thank you for your help.

Regards.

Daiju Kato
e-mail:dkato(at)luna(dot)email(dot)ne(dot)jp