Re: Solaris 9 and PgSQL 8.1.3 - createdb Link Fails

I tried the following:

- Compile PgSQL versions 8.1.2, 8.0.7, 7.4.12 on this new system and
another similar system
- Install readline 5.1 and repeat the above
- "gmake -j 4" on 8 CPU system
- Compile PgSQL 8.1.3 on the original system I loaded PgSQL onto

The first three failed, but the last completed successfully. Looking
further into the failure, I noticed that the build that completed was
running an old version of GNU make (3.79.1), while the failures
occurred with GNU make 3.81beta2. We installed the GNU make 3.81beta2
http://make.paulandlesley.org/make-3.81beta2.tar.bz2 to solve the
problem of getting "interrupted system call" errors when running
parallel builds with the source code stored on a NFS server. I
haven't seen any other software packages fail to build when using
this GNU make.

There might be something screwy in the PostgreSQL makefiles though
since I did notice the following behavior.

GNU make 3.81beta2 initial build
==========================
[snip]
gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Winline -Wendif-
labels -fno-strict-aliasing -DFRONTEND -I../../../src/bin/pg_dump -
I../../../src/bin/psql -I../../../src/interfaces/libpq -I../../../src/
include -I/soft/gnu/readline/5.1/include -c -o createdb.o createdb.c
[snip]
gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Winline -Wendif-
labels -fno-strict-aliasing -DFRONTEND -I../../../src/bin/pg_dump -
I../../../src/bin/psql -I../../../src/interfaces/libpq -I../../../src/
include -I/soft/gnu/readline/5.1/include -L../../../src/port -Wl,-R/
usr/local/postgresql-8.1.3/lib createdb.c createdb.o common.o
dumputils.o ../../../src/backend/parser/keywords.o -o createdb
ld: fatal: symbol `main' is multiply-defined:
(file /tmp/ccIwnYOH.o type=FUNC; file createdb.o type=FUNC);
ld: fatal: File processing errors. No output written to createdb
==========================

GNU make 3.81beta2 second build (ie: don't run "gmake clean")
==========================
[snip]
gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Winline -Wendif-
labels -fno-strict-aliasing createdb.o common.o dumputils.o ../../../
src/backend/parser/keywords.o -L../../../src/port -lpgport -L../../../
src/interfaces/libpq -lpq -L../../../src/port -Wl,-R/usr/local/
postgresql-8.1.3/lib -lpgport -lz -lreadline -ltermcap -lrt -lresolv -
lgen -lsocket -lnsl -ldl -lm -o createdb
[snip]
==========================

GNU make 3.80 initial build
==========================
[snip]
gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Winline -Wendif-
labels -fno-strict-aliasing -DFRONTEND -I../../../src/bin/pg_dump -
I../../../src/bin/psql -I../../../src/interfaces/libpq -I../../../src/
include -I/soft/gnu/readline/5.1/include -c -o createdb.o createdb.c
[snip]
gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Winline -Wendif-
labels -fno-strict-aliasing createdb.o common.o dumputils.o ../../../
src/backend/parser/keywords.o -L../../../src/port -lpgport -L../../../
src/interfaces/libpq -lpq -L../../../src/port -Wl,-R/usr/local/
postgresql-8.1.3/lib -lpgport -lz -lreadline -ltermcap -lrt -lresolv -
lgen -lsocket -lnsl -ldl -lm -o createdb
[snip]
==========================

This problem is not isolated to the createdb command. It happened on
every single binary in .../src/bin/scripts/. I needed to run the
build 10 times to make it through this directory when using the
latest version of GNU make. Note that the initial build of the files
in .../src/bin/scripts/ that fail all have greatly different syntax
on the link command than the ones that link properly. When the make
is run using the released version of GNU make or a when the link is
reattempted with 3.81beta2, the link arguments are much different.

I've gotten the software compile, but wanted to make sure people were
aware of this issue.

Steve

On Feb 22, 2006, at 11:52 AM, Steve Waltner wrote:
> Not on this system.
>
> I successfully compiled version 7.2.1 on a different Solaris 9
> system back in Nov 2004. I could always copy that installation across.
>
> I receive the same "main multiply-defined" error when trying to
> compile PostgreSQL 8.0.7 and 8.1.2 on this same system. I'm trying
> 7.4.12 now and will also install readline to see if the "./
> configure --without-readline" option is giving me trouble.
>
> Steve
>
> On Feb 22, 2006, at 11:33 AM, Mark Round wrote:
>> Do you have an older version of PostgreSQL installed ?
>>
>> On 2/22/06, Steve Waltner <steve(dot)waltner(at)engenio(dot)com> wrote:
>>> I have been unable to get PostreSQL 8.1.3 to compile on Solaris 9.