Re: Roadmap for Postgres on AIX

John R Pierce <pierce@xxxxxxxxxxxx> · Mon, 18 Mar 2013 16:20:09 -0700



    On 3/18/2013 3:39 PM, Wasim Arif wrote:

    
      What is the road map for Postgres on the AIX platform? I
        understand that the pg build farm contains an AIX 5.3 server;
        are there any plans to upgrade to 6.1 and 7.1?
      Our servers run on AIX and we are evaluating using Postgres
        as the RDBMS. Part of my evaluation is understanding where the
        pg team is headed with AIX, and if it is considered a supported
        platform for the foreseeable future.
    
    
    I have been building postgres for my companies inhouse use on AIX
    6.1 without any issues.   I am using IBM XLC to compile it, and I'm
    building it with plpgsql and plperl support, but not any of the
    others (we don't use them).   I had to compile my own zlib and
    readline libraries to go with it, which I static link to simplify
    deployment.    because I link it with readline, my builds are GPL
    tainted and can't be distributed as-is, anyways, my employers
    policies would not allow me to do that.  

    
    I use a few tools from the IBM AIX Linux Toolkit for convenience,
    notably gtar, gmake, and wget.   XLC is installed in /usr/vac 

    
    my build script looks something like...

    
      cd
          $HOME/src
      wget
          http://..../zlib-1.2.5.tar.gz
      gtar
          xzf zlib-1.2.5.tar.gz
      cd
          zlib-1.2.5
      export
          OBJECT_MODE=64
      CC=/usr/vac/bin/xlc
          CFLAGS="-q64 -mcpu=pwr6 -O2"
        AR="/usr/bin/ar"
        ./configure --prefix=$HOME --64 --static
      gmake
          clean
      gmake
      gmake
          install
    
    
      cd
          $HOME/src
      wget
          http://..../readline-6.1.tar.gz
      gtar
          xzf readline-6.1.tar.gz
      cd
          readline-6.1
      export
          OBJECT_MODE=64
      CC=/usr/vac/bin/xlc
          CFLAGS="-q64" AR="/usr/bin/ar"
        ./configure --prefix=$HOME --64 --static
      gmake
          clean
      gmake
      gmake
          install

          
          cd
              ~/src
          wget
              http://..../postgresql-9.1.6.tar.gz
          gtar
              xzf postgresql-9.1.6.tar.gz
          cd
              postgresql-9.1.6
        
        
        export
            OBJECT_MODE=64
        CC=/usr/vacpp/bin/xlc
            CFLAGS="-q64
            -I$HOME/src/include -O2 -qarch=pwr5 -qtune=balanced"
          \
            LDFLAGS="-L$HOME/src/lib"
          AR="/usr/bin/ar"
          \
            ./configure --prefix=/opt/pgsql91
        gmake
            clean
        gmake
        cd
            contrib
        gmake
        cd
            ..
        gmake
            check
        su
            -c "gmake install"
        

      cd
          /opt
      gtar
          cvzf /tmp/postgresql-9.1.6-AIX-1.0.tar.gz pgsql91
    
    
    this tarball is what we use on our production servers, we run
    postgres from /opt/pgsql91/...

    
    -- 
john r pierce                                      37N 122W
somewhere on the middle of the left coast