Open Source Development

Power Open Source Development

Explore the open source tools and capabilities for building and deploying modern applications on IBM Power platforms including AIX, IBM i, and Linux.


#Power


#Power

 View Only
Expand all | Collapse all

Newer version of PostgreSQL in AIX Toolbox

  • 1.  Newer version of PostgreSQL in AIX Toolbox

    Posted Wed May 28, 2025 10:18 AM

    Hello,

    Does AIX Toolbox community plan to provide a newer version of PostgreSQL? (now version 15 is available

    e.g. we would be interested in the PostgreSQL16 version.



    ------------------------------
    Kamil P
    ------------------------------

    #AIXOpenSource


  • 2.  RE: Newer version of PostgreSQL in AIX Toolbox

    Posted Thu May 29, 2025 03:05 AM

    Hello Kamil

    There are currently no plans to upgrade PostgreSQL. Are you looking for any specific features available in PostgreSQL16?

    Thanks 
    Sumitra



    ------------------------------
    Sumitra Dawn
    ------------------------------



  • 3.  RE: Newer version of PostgreSQL in AIX Toolbox

    Posted Fri May 30, 2025 03:57 AM
    Edited by Kamil P Fri May 30, 2025 04:32 AM

    Hello,
    My entire corporation runs on PostgreSQL16. We wanted to offer PostgreSQL on AIX and we need it in at least version 16. Of course there is a possibility of compilation from source, but the availability of the binary in Toolbox makes installation much easier.
    ------------------------------
    Kamil P
    ------------------------------



  • 4.  RE: Newer version of PostgreSQL in AIX Toolbox

    Posted Wed August 27, 2025 09:31 AM

    I would like to draw your attention to the urgent need for updating PostgreSQL packages available in the IBM AIX Toolbox. At the moment, only version 15 is available, while the PostgreSQL community already maintains version 17, and version 18 is about to be released. Such a significant delay creates serious limitations in terms of both performance and security for systems running on AIX.

    PostgreSQL is a critical component in many enterprise and production environments, and the lack of current versions directly impacts the adoption of AIX in modern database deployments. Specifically:

    1. Security – older versions do not contain the latest security fixes, which exposes systems to potential vulnerabilities. Regular updates are a standard requirement in enterprise environments.
    2. Performance – versions 16 and 17 introduce significant improvements, such as better parallelism, more efficient query planning, I/O optimizations, and enhancements for handling large workloads.
    3. New features – missing access to newer versions limits the use of advanced capabilities, including improved replication logic, enhanced validation mechanisms, and new SQL functionality important in modern enterprise deployments.
    4. Consistency and support – many organizations' database modernization strategies require staying aligned with supported PostgreSQL versions. The absence of current builds for AIX forces workarounds or, in some cases, abandonment of AIX despite its stability and performance benefits.

    Considering that AIX is widely used in mission-critical environments, providing up-to-date PostgreSQL packages in the AIX Toolbox is essential to fully leverage the strengths of this platform while maintaining compliance with best practices for security and performance.

    I kindly request that you prioritize the compilation and release of the latest PostgreSQL version (at least 17) in the AIX Toolbox. This will allow organizations to continue adopting AIX as a reliable and efficient database platform without compromising security or performance.

    Thank you in advance for your feedback regarding plans in this area.



    ------------------------------
    Rafał Bednarski
    ------------------------------



  • 5.  RE: Newer version of PostgreSQL in AIX Toolbox

    Posted Thu August 28, 2025 09:49 AM

    There is a plan to update Postgresql to 17 or later version in AIX Toolbox soon. 



    ------------------------------
    Ayappan P
    ------------------------------



  • 6.  RE: Newer version of PostgreSQL in AIX Toolbox

    Posted Mon September 22, 2025 06:18 AM

    That is excellent news, thank you very much for the update.
    Could you please let me know when we can expect the new PostgreSQL package to be available for installation in the AIX Toolbox?
    Additionally, I would like to ask if these updates could be delivered on a more regular basis to ensure proper PostgreSQL functionality, timely bug fixes, and the latest security patches. This is very important for us in order to use the solution safely and effectively in production environments.



    ------------------------------
    Rafał Bed
    ------------------------------



  • 7.  RE: Newer version of PostgreSQL in AIX Toolbox

    Posted Wed September 24, 2025 10:26 AM

    Hi,

    You can expect it in the coming quarter. 

    We are currently building release 18 as of now. Once the build and testing phase is done and all goes smoothly post approvals, then you can expect regular updates. 

    We will keep you updated in the next 2 weeks about the same.



    ------------------------------
    Aditya Kamath
    ------------------------------



  • 8.  RE: Newer version of PostgreSQL in AIX Toolbox

    Posted Mon September 29, 2025 08:51 AM

    UPDATE:

    We have built the latest release version, 18, of Postgres, and initial testing is also complete. Our team will do further functional testing, DNF testing, and additional validations in the coming weeks. Following the required reviews and approvals, we expect to release Postgres in the next couple of weeks if further testing goes well. We will keep you informed of any updates/changes in the timeline.

    Thank you for your interest in Postgres. 



    ------------------------------
    Aditya Kamath
    ------------------------------



  • 9.  RE: Newer version of PostgreSQL in AIX Toolbox

    Posted Thu October 23, 2025 12:34 PM

    Hi,

    Thank you for the previous updates.
    We've noticed that the AIX Toolbox still provides only PostgreSQL version 15, and we haven't seen a new release yet.

    Could you please share the current status of PostgreSQL 18 for AIX?
    We're very interested in testing and deploying the latest PostgreSQL version on IBM Power systems, as it's crucial for us to take full advantage of the new performance and HA improvements available in PostgreSQL 17/18.

    Any estimated release timeline or confirmation that the build is nearing publication would be highly appreciated.

    Thank you in advance for your help and continued work on the AIX packages.

    Best regards,



    ------------------------------
    Rafał Bed
    ------------------------------



  • 10.  RE: Newer version of PostgreSQL in AIX Toolbox

    Posted 30 days ago

    Hi,

    Thank you for checking in.

    We have completed the DNF, functional, and ecosystem testing. All is good, and it works smoothly in AIX.
    AIX users will get Postgres 18 and updates as community releases in the future.

    Currently the package is under final review, which is expected to be completed next week. We also are in the process of updating some dependencies as well, needed for Postgres 18 and are writing a blog on how AIX users can migrate.

    So in the first week of November we will release Postgres 18 in AIX Toolbox. 



    ------------------------------
    Aditya Kamath
    ------------------------------



  • 11.  RE: Newer version of PostgreSQL in AIX Toolbox

    Posted 16 days ago

    Hi,

    https://community.ibm.com/community/user/blogs/aditya-kamath/2025/11/06/postgresql18-and-pgvector-on-aix

    PostgreSQL 18 is available. Kindly read the blog. Let us know if you need anything. Also, do try pgvector as well.



    ------------------------------
    Aditya Kamath
    ------------------------------



  • 12.  RE: Newer version of PostgreSQL in AIX Toolbox

    Posted 9 days ago

    That's really good news! Especially since the Postgres website shows that support for AIX was dropped with v18. (Source: https://wiki.postgresql.org/wiki/AIX)



    ------------------------------
    Niklas Vosskoetter
    Deputy Team Lead & System Engineer Unix and Cloud Service Power
    ------------------------------