Thread: Roadmap for Postgres on AIX

Roadmap for Postgres on AIX

From
Wasim Arif
Date:
Hi guys,

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.

Any pointers would be appreciated.

Thanks,
Wasim.


Re: Roadmap for Postgres on AIX

From
John R Pierce
Date:
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

Re: Roadmap for Postgres on AIX

From
Tom Lane
Date:
Wasim Arif <wasimarif@gmail.com> writes:
> 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?

The reason there's an AIX 5.3 buildfarm member is that someone cares
enough about preserving portability to that platform to provide a
buildfarm member.  If you're worried about other AIX releases, I suggest
you do likewise.  It's not a huge burden.  Basic info about it is here:
http://buildfarm.postgresql.org/cgi-bin/register-form.pl

By and large, our approach to AIX is the same as to any other platform:
we'll support it as long as users of the platform provide testing and
any necessary portability fixes.  That burden might fall more directly
on you, as one of a relatively small number of users, than it would on
somebody using say Linux or BSD.  But as long as you are willing to do
some of the work you need not fear that we're planning to abandon you.

(FWIW, I believe there was a more-recent AIX version in the buildfarm
till recently.  Don't know why its owner stopped running it.)

            regards, tom lane


Re: Roadmap for Postgres on AIX

From
Wasim Arif
Date:
Thanks for the detailed and quick response guys.

-Wasim.

On Mon, Mar 18, 2013 at 6:00 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Wasim Arif <wasimarif@gmail.com> writes:
> 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?

The reason there's an AIX 5.3 buildfarm member is that someone cares
enough about preserving portability to that platform to provide a
buildfarm member.  If you're worried about other AIX releases, I suggest
you do likewise.  It's not a huge burden.  Basic info about it is here:
http://buildfarm.postgresql.org/cgi-bin/register-form.pl

By and large, our approach to AIX is the same as to any other platform:
we'll support it as long as users of the platform provide testing and
any necessary portability fixes.  That burden might fall more directly
on you, as one of a relatively small number of users, than it would on
somebody using say Linux or BSD.  But as long as you are willing to do
some of the work you need not fear that we're planning to abandon you.

(FWIW, I believe there was a more-recent AIX version in the buildfarm
till recently.  Don't know why its owner stopped running it.)

                        regards, tom lane

Re: Roadmap for Postgres on AIX

From
Thomas Munro
Date:
On 19 March 2013 01:00, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Wasim Arif <wasimarif@gmail.com> writes:
> 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?

The reason there's an AIX 5.3 buildfarm member is that someone cares
enough about preserving portability to that platform to provide a
buildfarm member.  If you're worried about other AIX releases, I suggest
you do likewise.  It's not a huge burden.  Basic info about it is here:
http://buildfarm.postgresql.org/cgi-bin/register-form.pl

By and large, our approach to AIX is the same as to any other platform:
we'll support it as long as users of the platform provide testing and
any necessary portability fixes.  That burden might fall more directly
on you, as one of a relatively small number of users, than it would on
somebody using say Linux or BSD.  But as long as you are willing to do
some of the work you need not fear that we're planning to abandon you.

For those organisations running PostgreSQL on AIX, I wonder if it would be possible for a member of 'IBM PartnerWorld' to use the free 'Virtual Loaner' programme[1] to set up build farm members on a range of AIX versions and POWER chips.

My employer is in this category, but I am not in a position to contribute company time patches or resources currently (although that might change).  From memory we've had to make a couple of local tweaks to makefiles for our particular versions of things, although we are mostly focussed on clients on AIX, not the server.  But perhaps some of the other (rare!) AIX users from the list might be able to look into VPL farm animals?

[1] http://www-304.ibm.com/partnerworld/wps/pub/systems/vlp/index

Re: Roadmap for Postgres on AIX

From
Stefan Kaltenbrunner
Date:
On 04/17/2013 07:45 PM, Thomas Munro wrote:
> On 19 March 2013 01:00, Tom Lane <tgl@sss.pgh.pa.us
> <mailto:tgl@sss.pgh.pa.us>> wrote:
>
>     Wasim Arif <wasimarif@gmail.com <mailto:wasimarif@gmail.com>> writes:
>     > 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?
>
>     The reason there's an AIX 5.3 buildfarm member is that someone cares
>     enough about preserving portability to that platform to provide a
>     buildfarm member.  If you're worried about other AIX releases, I suggest
>     you do likewise.  It's not a huge burden.  Basic info about it is here:
>     http://buildfarm.postgresql.org/cgi-bin/register-form.pl
>
>     By and large, our approach to AIX is the same as to any other platform:
>     we'll support it as long as users of the platform provide testing and
>     any necessary portability fixes.  That burden might fall more directly
>     on you, as one of a relatively small number of users, than it would on
>     somebody using say Linux or BSD.  But as long as you are willing to do
>     some of the work you need not fear that we're planning to abandon you.
>
>
> For those organisations running PostgreSQL on AIX, I wonder if it would
> be possible for a member of 'IBM PartnerWorld' to use the free 'Virtual
> Loaner' programme[1] to set up build farm members on a range of AIX
> versions and POWER chips.
>
> My employer is in this category, but I am not in a position to
> contribute company time patches or resources currently (although that
> might change).  From memory we've had to make a couple of local tweaks
> to makefiles for our particular versions of things, although we are
> mostly focussed on clients on AIX, not the server.  But perhaps some of
> the other (rare!) AIX users from the list might be able to look into VPL
> farm animals?
>
> [1] http://www-304.ibm.com/partnerworld/wps/pub/systems/vlp/index

hmm looks kinda interesting and better POWER coverage on the BF would be
nice - if your company cannot donate time, maybe they could get someone
from the community access to those systems for setting up bf animals?


Stefan




Re: Roadmap for Postgres on AIX

From
KimmoHintikka
Date:
Hi,

I got this page by accident trying find more info on tests EnterpriseDB did
with PostgressSQL Power Linux.

Anyway as I work IBM Power sales rep for Finland myself, please sent me
little bit more info on what kind of test you have in mind. (Do you just
want few core's to test it works / or bigger instance for performance
testing? For how long?)

I can see when we would have test machine available trough partner world.

If you don't want to ping your specific test scenario on public forum please
sent me a mail kimmo.hintikka@ie.ibm.com or ping on  linkedin
<http://www.linkedin.com/in/kimmohintikka>

Otherwise just answer here and I get back to you.



--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Roadmap-for-Postgres-on-AIX-tp5748857p5765794.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.