Re: NEED RPM FILE OF LATEST POSTGRE supported for AIX 7.2

On Wed, Mar 29, 2023 at 8:16 PM Amit Regmi <amitregmi111@gmail.com> wrote:
> Since i am new this this AIX world .Could you suggest me the latest GCC supported for AIX 7.2 along with its
dependencies.
> newer GCC:
> Version ???

Sorry I don't know anything about software distribution on AIX.
Apparently GCC 10 is available in an RPM here?

https://www.ibm.com/support/pages/aix-toolbox-open-source-software-downloads-alpha

Ahh, they also have packages for PostgreSQL 11.18.  11.x is in its
last year of support (by us), so maybe try to contact the maintainers
and see what their major version upgrade plan is?  It looks like they
are tracking our minor (bug fix) releases, but with a few months of
lag, but they still don't have our 12-15 releases that are 1-4 years
old now.  Have they just not got around to it yet, or is this their
way of dropping PostgreSQL?  Did they stop packaging PostgreSQL
because the [defunct] ATOS freeware project was doing them, i.e. did
those packages 'move' there, and then die?

There may be other packaging projects out there... if so I haven't
heard of them myself (but that's not saying much, I'm not an active
AIX guy, I just retain a weird curiosity about those systems having
used very large AIX systems a decade or so ago, which already felt
like it was the end of times for proprietary Unix... but, man, those
things had a *lot* of CPUs).

The ATOS project was tracking newer releases IIRC, and I was aware of
that because one or two of the maintainers would come onto the
pgsql-hackers mailing list occasionally to discuss patches to fix
silly scalability problems on that platform that require small amounts
of special API adjustments (mainly huge pages, maybe also pollset vs
poll, patches I've written 'blind' before but couldn't find anyone
interested in testing).  I personally take the absence of anyone
interested in easy-to-fix problems like that, and the lack of
packaging, as a clue that there are by now no serious users of
PostgreSQL on AIX...  But I could be guessing wrong?

Out of curiosity, are you trying to set up a database server, or just
connect with client libraries/tools?  If the latter, from what
language?