Postgres will not build on AIX with either of the following options to the
configure script:
--with-uuid=e2fs
--with-uuid=ossp
so I was using --with-uuid=bsd which does work except for the arc4random
undefined symbol error I was getting.
I removed the --with-uuid=bsd option to the configure script and everything
builds including the contrib subdir except
the uuid-ossp subdir like we want.
Heres the configure command:
./configure \
--prefix="$BUILD_DIR/pgsql-$POSTGRES_VERSION" \
--without-readline \
--without-zlib \
--with-openssl \
--with-includes="$BUILD_DIR"/openssl/include/openssl/ \
--with-libraries="$BUILD_DIR"/openssl/lib/ \
"$ADDITIONAL_FLAGS"
However, when I try to create a database I'm getting an out of memory error
(see below.) Any suggestions?
Thanks, Mark
-------------------------------------------------------------------------------------------------------------------------------
Command: ${postgresDir}/bin/initdb -D ./data -U dbmsowner -W
<msgs>
<enter pwd>
<msgs>
TopMemoryContext: 75328 total in 5 blocks; 33264 free (32 chunks); 42064 used
TopTransactionContext: 524288 total in 7 blocks; 106872 free (26 chunks);
417416 used
TableSpace cache: 8192 total in 1 blocks; 5064 free (0 chunks); 3128 used
<.....>
Relcache by OID: 8192 total in 1 blocks; 1760 free (0 chunks); 6432 used
CacheMemoryContext: 2097152 total in 9 blocks; 808960 free (10 chunks);
1288192 used
index info: 2048 total in 2 blocks; 808 free (0 chunks); 1240 used:
pg_description_o_c_o_index
relation rules: 16384 total in 5 blocks; 4840 free (0 chunks); 11544 used:
pg_replication_slots
relation rules: 16384 total in 5 blocks; 4544 free (1 chunks); 11840 used:
pg_statio_all_sequences
relation rules: 49152 total in 9 blocks; 7160 free (3 chunks); 41992 used:
pg_statio_all_indexes
<...etc...>
Grand total: 3779872 bytes in 241 blocks; 1220984 free (137 chunks); 2558888
used
2022-06-13 23:20:12.911 EDT [15270042] FATAL: out of memory
2022-06-13 23:20:12.911 EDT [15270042] DETAIL: Failed on request of size 8192
in memory context "ExprContext".
2022-06-13 23:20:12.911 EDT [15270042] STATEMENT: SELECT
pg_import_system_collations('pg_catalog');
-----Original Message-----
From: Tom Lane <[email protected]>
Sent: Tuesday, May 31, 2022 11:20 AM
To: Mark Hill <[email protected]>
Cc: [email protected]
Subject: Re: Build Postgres On AIX
[You don't often get email from [email protected]. Learn why this is important
at https://aka.ms/LearnAboutSenderIdentification ]
EXTERNAL
Mark Hill <[email protected]> writes:
> I'm building Postgres 14.2 on AIX. Apparently the arc4random function is
> not available in the AIX system libraries. The build
> fails when it tries to build
> postgresql-14.2/contrib/uuid-ossp/uuid-ossp.c because of the use of
> arc4random in that source file.
AFAICS arc4random is only referenced in the "BSD" code paths, so you must have
tried to specify --with-uuid=bsd. It's not too surprising that that didn't
work. As per the docs, your other alternatives are to use the OSSP library or
the e2fsprogs library. Or you could just not build uuid-ossp; it's fairly
vestigial these days, now that we offer gen_random_uuid() in core.
regards, tom lane
