RE: AIX support

Hi Tom,

> Also we ran it on master and all the tests are passing

>> douc:HEAD [15:30:25] running make PL installcheck (C)...
>> douc:HEAD [15:30:29] restarting db (C)...
>> douc:HEAD [15:30:32] running make contrib installcheck (C)...
>> douc:HEAD [15:31:20] restarting db (C)...
>> douc:HEAD [15:31:22] running make test-modules installcheck (C)...
>> douc:HEAD [15:31:59] stopping db (C)...
>> douc:HEAD [15:32:08] running make ecpg check ...
>> douc:HEAD [15:32:29] OK
>> Branch: HEAD
>> All stages succeeded

>Good, but I don't see a report on the buildfarm server?

This was run locally on the node.
Today I ran the test locally first and all tests passed. Logs at below location on p9-aix1-postgres1

pgsql(at)p9-aix1-postgres1::bfarm19
## pwd
/tmp/bfarm19

pgsql(at)p9-aix1-postgres1::bfarm19
## ls
bfarm19.send.26020449.log
douc.lastrun-logs/ <<<<< All logs

pgsql(at)p9-aix1-postgres1::bfarm19
## tail bfarm19.send.26020449.log
douc:HEAD [06:03:54] running make PL installcheck (C)...
douc:HEAD [06:03:58] restarting db (C)...
douc:HEAD [06:04:00] running make contrib installcheck (C)...
douc:HEAD [06:04:44] restarting db (C)...
douc:HEAD [06:04:47] running make test-modules installcheck (C)...
douc:HEAD [06:05:24] stopping db (C)...
douc:HEAD [06:05:25] running make ecpg check ...
douc:HEAD [06:05:45] OK
Branch: HEAD
All stages succeeded

In the next run I tried to push the logs to server, but the last test case failed.

douc:HEAD [08:13:29] restarting db (C)...
douc:HEAD [08:13:32] running make test-modules installcheck (C)...
douc:HEAD [08:14:31] failed at stage TestModulesCheck-C

The logs are pushed to the server
https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=douc&dt=2026-02-26%2006%3A58%3A38

I see below errors in the log file
# +++ tap install-check in src/test/modules/worker_spi +++
not ok 1 - test_shm_mq 483 ms
1..1
# 1 of 1 tests failed.
# The differences that caused some tests to fail can be viewed in the file "/home/pgsql/buildFarm/bfarm-19.1/buildroot/HEAD/pgsql.build/src/test/modules/test_shm_mq/regression.diffs".
# A copy of the test summary that you see above is saved in the file "/home/pgsql/buildFarm/bfarm-19.1/buildroot/HEAD/pgsql.build/src/test/modules/test_shm_mq/regression.out".
gmake[1]: *** [../../../../src/makefiles/pgxs.mk:433: installcheck] Error 1
gmake[1]: Leaving directory '/home/pgsql/buildFarm/bfarm-19.1/buildroot/HEAD/pgsql.build/src/test/modules/test_shm_mq'
gmake: *** [Makefile:84: installcheck-test_shm_mq-recurse] Error 2

Below is the error in the diff file

+ERROR: could not register background process

+HINT: You may need to increase "max_worker_processes".

After setting the ‘max_worker_processes=16”, in the "./inst/data-C/postgresql.conf” and ran

## gmake check installcheck-C

All the tests passed. Below is the log
/tmp/bfarm19/installcheck-C.log

The above test_shm_mq pased here
# +++ regress check in src/test/modules/test_shm_mq +++
# initializing database system by copying initdb template
# using temp instance on port 58928 with PID 41156962
ok 1 - test_shm_mq 6307 ms
1..1
# All 1 tests passed.

Warm regards,
Sriram.