Re: Roadmap for Postgres on AIX
| От | John R Pierce |
|---|---|
| Тема | Re: Roadmap for Postgres on AIX |
| Дата | |
| Msg-id | 5147A129.2000005@hogranch.com обсуждение исходный текст |
| Ответ на | Roadmap for Postgres on AIX (Wasim Arif <wasimarif@gmail.com>) |
| Список | pgsql-general |
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/srcwget http://..../zlib-1.2.5.tar.gzgtar xzf zlib-1.2.5.tar.gzcd zlib-1.2.5export OBJECT_MODE=64CC=/usr/vac/bin/xlc CFLAGS="-q64 -mcpu=pwr6 -O2" AR="/usr/bin/ar" ./configure --prefix=$HOME --64 --staticgmake cleangmakegmake installcd $HOME/srcwget http://..../readline-6.1.tar.gzgtar xzf readline-6.1.tar.gzcd readline-6.1export OBJECT_MODE=64CC=/usr/vac/bin/xlc CFLAGS="-q64" AR="/usr/bin/ar" ./configure --prefix=$HOME --64 --staticgmake cleangmakegmake install
cd ~/srcwget http://..../postgresql-9.1.6.tar.gzgtar xzf postgresql-9.1.6.tar.gzcd postgresql-9.1.6export OBJECT_MODE=64CC=/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/pgsql91gmake cleangmakecd contribgmakecd ..gmake checksu -c "gmake install"cd /optgtar cvzf /tmp/postgresql-9.1.6-AIX-1.0.tar.gz pgsql91this 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
В списке pgsql-general по дате отправления: