Re: 64 bit PostgreSQL 8.3.6 build on AIX 5300-09-02-0849 with IBM XL C/C++ 10.1.0.1 - initdb fails (could not dump unrecognized node type: 650)

OK, I've managed to compile a 32 bit PostgreSQL successfully and it runs. I'm not yet sure if the issues are due to
usingthe C++ compiler to compile C code, optimization flags or 64 bit builts, but I'll rebuilt it a few times to
pinpointthe real issue.<br /><br />Either way, I think it was my mistake to use xlC_r instead of xlc_r. Thanks a lot
forthe support.<br />If I get these issues sorted out, I'll see if I can add the machine to the buildfarm.<br /><br
/>I'verecompiled it with clean environment variables (no CC defined, etc), using xlc (/usr/vac/bin/xlc_r), the C
compilerinstead of using xlC_r (the C++ compiler). No -q64 (64 bit build) and using:<br /><br />CFLAGS='-qnooptimize'
./configure--enable-cassert --enable-debug --with-includes=/opt/freeware/include --with-libraries=/opt/freeware/lib
--enable-thread-safety<br/><br />I see gmake using:<br />xlc -qnooptimize -qnoansialias -g -I../../../src/include
-I/opt/freeware/include -c -o pg_enum.o pg_enum.c<br /><br />Now initdb runs fine.<br /><br />phobos$
/usr/local/pgsql/bin/initdb-D /usr/local/pgsql/data<br />The files belonging to this database system will be owned by
user"postgres".<br />This user must also own the server process.<br /><br />The database cluster will be initialized
withlocale en_US.<br />The default database encoding has accordingly been set to LATIN1.<br />The default text search
configurationwill be set to "english".<br /><br />fixing permissions on existing directory /usr/local/pgsql/data ...
ok<br/> creating subdirectories ... ok<br />selecting default max_connections ... 100<br />selecting default
shared_buffers/max_fsm_pages... 32MB/204800<br />creating configuration files ... ok<br />creating template1 database
in/usr/local/pgsql/data/base/1 ... ok<br /> initializing pg_authid ... ok<br />initializing dependencies ... ok<br
/>creatingsystem views ... ok<br />loading system objects' descriptions ... ok<br />creating conversions ... ok<br
/>creatingdictionaries ... ok<br />setting privileges on built-in objects ... ok<br /> creating information schema ...
ok<br/>vacuuming database template1 ... ok<br />copying template1 to template0 ... ok<br />copying template1 to
postgres... ok<br /><br />WARNING: enabling "trust" authentication for local connections<br /> You can change this by
editingpg_hba.conf or using the -A option the<br />next time you run initdb.<br /><br />Success. You can now start the
databaseserver using:<br /><br />    /usr/local/pgsql/bin/postgres -D /usr/local/pgsql/data<br /> or<br />   
/usr/local/pgsql/bin/pg_ctl-D /usr/local/pgsql/data -l logfile start<br /><br /><br /><div class="gmail_quote">On Mon,
Feb9, 2009 at 9:40 AM, Tom Lane <span dir="ltr"><<a href="mailto:tgl@sss.pgh.pa.us">tgl@sss.pgh.pa.us</a>></span>
wrote:<br/><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex;
padding-left:1ex;"><div class="Ih2E3d">Mihai Criveti <<a href="mailto:cmihai@boreas.ro">cmihai@boreas.ro</a>>
writes:<br/></div><div class="Ih2E3d">> So if this is a compiler bug, it certainly isn't an obvious one. I'll dig<br
/>> deeper to see how I can convince configure to use -qnooptimize.<br /><br /></div>Set CFLAGS in its environment.
 Thedefault is set in src/template/aix<br />      CFLAGS="-O2 -qmaxmem=16384 -qsrcmsg -qlonglong"<br /><div
class="Ih2E3d"><br/> > When I've used the build farm scripts, configure gives xlC_r these flags:<br /> >
configure:7117:xlC_r -q64 -o conftest -O2 -qmaxmem=16384 -qsrcmsg<br /> > -qlonglong -g
 -I/opt/freeware/include/libxml2  -L/opt/freeware/lib<br /> > conftest.c -lm  >&5<br /><br /></div>Dunno
wherethe -q64 came from ...<br /><div class="Ih2E3d"><br /> > 1506-396 (W) Option -qlonglong is incompatible with
option-qlanglvl=extc99<br /> > and is ignored.<br /><br /></div>Seems like these switches might need a revisit for
latestAIX.<br /><br />                        regards, tom lane<br /></blockquote></div><br /><br clear="all" /><br
/>--<br />Criveti Mihai<br /><a href="http://unixsadm.blogspot.com">http://unixsadm.blogspot.com</a><br /><br />