Обсуждение: Problem compiling PostgreSQL 8.1.4 on AIX.

Hello,

I am trying to set up pgsql on AIX 5.3L (2/2006)
I am using gcc 3.3 (the version supplied by IBM  (Linux application toolkit for AIX))
running make produced the following output

rm -rf ./testtablespace
mkdir ./testtablespace
/bin/sh ./pg_regress --temp-install --top-builddir=../../.. --temp-port=55432 --schedule=./parallel_schedule --multibyte=SQL_ASCII --load-language=plpgsql
============== removing existing temp installation    ==============
============== creating temporary installation        ==============
============== initializing database system           ==============

pg_regress: initdb failed
Examine ./log/initdb.log for the reason.

gmake[2]: *** [check] Error 2
gmake[2]: Leaving directory `/installs/PostgreSQL/postgresql-8.1.4/src/test/regress'
gmake[1]: *** [check] Error 2
gmake[1]: Leaving directory `/installs/PostgreSQL/postgresql-8.1.4/src/test'
gmake: *** [check] Error 2
make: 1254-004 The error code from the last command is 2.


Stop.

and I find the following in the logs.
(attached)

I am using user pgsql which was created specifically for postgre who owns the installation directory.
the directories are chmoded 777 just to make sure no permission are causing problems.

any clues?

I have updated AIX 5.3L (suma update) to the latest level.
I have tried newer flavours of gcc
(first 4.0.0-1 from Linux Toolbox for AIX then 4.1.1)

same error:

============== removing existing temp installation    ==============
============== creating temporary installation        ==============
============== initializing database system           ==============

pg_regress: initdb failed
Examine ./log/initdb.log for the reason.

gmake[2]: *** [check] Error 2
gmake[2]: Leaving directory `/installs/PostgreSQL/postgresql-8.1.4/src/test/regress'
gmake[1]: *** [check] Error 2
gmake[1]: Leaving directory `/installs/PostgreSQL/postgresql-8.1.4/src/test'
gmake: *** [check] Error 2
make: 1254-004 The error code from the last command is 2.


Stop.
> gcc --version
gcc (GCC) 4.1.1
Copyright (C) 2006 Free Software Foundation, Inc.
This is free software; see the source for copying conditions.  There is NO
warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.

the log says
> tail ./src/test/regress/log/initdb.log
creating directory /installs/PostgreSQL/postgresql-8.1.4/src/test/regress/./tmp_check/data/pg_multixact/members ... ok
creating directory /installs/PostgreSQL/postgresql-8.1.4/src/test/regress/./tmp_check/data/pg_multixact/offsets ... ok
creating directory /installs/PostgreSQL/postgresql-8.1.4/src/test/regress/./tmp_check/data/base ... ok
creating directory /installs/PostgreSQL/postgresql-8.1.4/src/test/regress/./tmp_check/data/base/1 ... ok
creating directory /installs/PostgreSQL/postgresql-8.1.4/src/test/regress/./tmp_check/data/pg_tblspc ... ok
selecting default max_connections ... 10
selecting default shared_buffers ... 50
creating configuration files ... ok
creating template1 database in /installs/PostgreSQL/postgresql-8.1.4/src/test/regress/./tmp_check/data/base/1 ... child process was terminated by signal 11
initdb: data directory "/installs/PostgreSQL/postgresql-8.1.4/src/test/regress/./tmp_check/data" not removed at user's request

any clues?

thanks in advance

Nezer J. Zaidenberg

Hello Tom,

Thanks for your prompt responses so far.

I have reconfigured and rebuild as you advice.

and i even have a core file. the problem is i have no clue which executable generated the core file.
I tried some that looked trivial but they were not it.

Is the a way to deduce based on the log or the script what executable has failed?

PS> I am fully capable of using gdb.

Thanks in advance.
 Nezer J. Zaidenebrg

found the process.
here it goes

# /usr/local/bin/gdb -c ./src/test/regress/tmp_check/data/core ./src/test/regress/tmp_check/install/usr/local/pgsql/bin/postgres
GNU gdb 6.5
Copyright (C) 2006 Free Software Foundation, Inc.
GDB is free software, covered by the GNU General Public License, and you are
welcome to change it and/or distribute copies of it under certain conditions.
Type "show copying" to see the conditions.
There is absolutely no warranty for GDB.  Type "show warranty" for details.
This GDB was configured as "powerpc-ibm-aix5.3.0.0"...
ptrace ldinfo: The process does not exist..
(gdb) bt
#0  0x3ff29d04 in ?? ()
#1  0x100206d0 in hash_search (hashp=0x2009bdc0, keyPtr=0x2009ddf8,
    action=HASH_ENTER, foundPtr=0x2009cc60 "") at dynahash.c:673
#2  0x1004e2bc in formrdesc (relationName=0x2001e660 "",
    relationReltype=4294967295, hasoids=25 '\031', natts=25, att=0x2001dc38)
    at relcache.c:1295
#3  0x1004fba0 in RelationCacheInitialize () at relcache.c:2185
#4  0x102033e0 in InitPostgres (dbname=0x20081ef8 "template1", username=0x0)
    at postinit.c:424
#5  0x10202d50 in BootstrapMain (argc=536872568, argv=0x20081e3c)
    at bootstrap.c:445
#6  0x10000604 in main (argc=5, argv=0x20081ec8) at main.c:294
(gdb)

thanks
Nezer J. Zaidenberg