Re: AIX support

Sriram RK <sriram.rk@outlook.com>

From: Sriram RK <sriram.rk@outlook.com>
To: Michael Paquier <michael@paquier.xyz>, Tom Lane <tgl@sss.pgh.pa.us>, Noah Misch <noah@leadboat.com>, "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>
Cc: Bruce Momjian <bruce@momjian.us>, Peter Eisentraut <peter@eisentraut.org>, Andres Freund <andres@anarazel.de>, Thomas Munro <thomas.munro@gmail.com>, Alvaro Herrera <alvherre@alvh.no-ip.org>, "tvk1271@gmail.com" <tvk1271@gmail.com>, Heikki Linnakangas <hlinnaka@iki.fi>
Date: 2024-05-06T14:12:22Z
Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →
  1. Restore AIX support.

  2. pg_createsubscriber: Improve error messages.

  3. Use <stdint.h> and <inttypes.h> for c.h integers.

  4. Stabilize jsonb_path_query test case.

  5. Fix C23 compiler warning

  6. pg_stat_statements: Add tests for nested queries with level tracking

  7. Add missing newline at the end of index_including.sql

  8. Remove AIX support

  9. Fix s_lock.h PPC assembly code to be compatible with native AIX assembler.

  10. Use a non-locking initial test in TAS_SPIN on PPC.

  11. Use LWSYNC in place of SYNC/ISYNC in PPC spinlocks, where possible.

  12. Use mutex hint bit in PPC LWARX instructions, where possible.

  13. Adjust TAS assembly as per recent discussions: use "+m"(*lock) everywhere

  14. Apple's assembler likes the inlined TAS syntax too, so no reason to

  15. Tighten up register usage for inline PPC version of tas().

  16. Put the isync where it's supposed to be.

  17. > > I'll re-check that with the ppc architecture guy here.

  18. Fix PPC s_lock operations to work correctly on multi-CPU machines.

  19. I tried to build PostgreSQL with the following step to see backends hung

  20. Complete merge of all old man page information.

  21. s_lock aix patch.

Hi Team, on further investigation we were able to resolve the perl issue by setting the right PERL env location. Earlier it was pointing to the 32bit perl, as a result the perl lib mismatch seems to be happening.
Now we have successfully built release 15 and 16 stable branches on the OSU lab node.

p9aix (OSU)
OS: AIX 72Z
    RELEASE 16
    p9aix:REL_16_STABLE [08:31:26] OK
    ======== log passed to send_result ===========
    Branch: REL_16_STABLE
    All stages succeeded

    RELEASE 15
    p9aix:REL_15_STABLE [08:55:37] OK
    ======== log passed to send_result ===========
    Branch: REL_15_STABLE
    All stages succeeded


Also, we had successfully built release 16 branch on our local nodes as well
OS: AIX 71C
    pgsql-aix71C:REL_16_STABLE [02:25:32] OK
    ======== log passed to send_result ===========
    Branch: REL_16_STABLE
    All stages succeeded

OS: AIX72Z
    pgsql-aix72Z:REL_16_STABLE [02:35:03] OK
    ======== log passed to send_result ===========
    Branch: REL_16_STABLE
    All stages succeeded

OS: AIX73D
    pgsql-aix73D:REL_16_STABLE [05:32:29] OK
    ======== log passed to send_result ===========
    Branch: REL_16_STABLE
    All stages succeeded


Regards,
Sriram.