Обсуждение: PostgreSQL on AIX platform

This email and any files transmitted with it are confidential, proprietary and intended solely for the individual or entity to whom they are addressed. If you have received this email in error please delete it immediately.

Can you please confirm if PostgreSQL 9.2.4 is supported on AIX 7 platform? In the following URL, it mentions support for AIX 6 (but not AIX 7) - http://www.postgresql.org/docs/9.2/static/installation-platform-notes.html

it should work fine, although I've not personally tested.


why 9.2.4 and not the latest 9.2.9 with 5 rounds of bug and security fixes ?   bug fixes since 9.2.4 include...
http://www.postgresql.org/docs/current/static/release-9-2-5.html
http://www.postgresql.org/docs/current/static/release-9-2-6.html
http://www.postgresql.org/docs/current/static/release-9-2-7.html
http://www.postgresql.org/docs/current/static/release-9-2-8.html
http://www.postgresql.org/docs/current/static/release-9-2-9.html


note that 9.2.6 and 9.2.9 both fixed some potential data and/or index corruption bugs.

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

This email and any files transmitted with it are confidential, proprietary and intended solely for the individual or entity to whom they are addressed. If you have received this email in error please delete it immediately.

Payal Shah wrote
> Can you please confirm if PostgreSQL 9.2.4 is supported on AIX 7 platform?
> In the following URL, it mentions support for AIX 6 (but not AIX 7) -
> http://www.postgresql.org/docs/9.2/static/installation-platform-notes.html
>
> As I understand from a different topic on this forum is that, we would
> need to download source code and compile on AIX using IBM XL C compiler.
> Can someone provide steps on how to do that?

All indications are that AIX as an OS, and probably any underlying
architectures it runs on, are capable of running all supported releases of
PostgreSQL.

However, per this:

http://www.postgresql.org/docs/9.2/interactive/supported-platforms.html

"A platform (that is, a CPU architecture and operating system combination)
is considered supported by the PostgreSQL development community if the code
contains provisions to work on that platform and it has recently been
verified to build and pass its regression tests on that platform. Currently,
most testing of platform compatibility is done automatically by test
machines in the PostgreSQL Build Farm."

http://buildfarm.postgresql.org/cgi-bin/show_status.pl

There is currently no official support, via continual regression testing, of
AIX since there has not been an AIX buildfarm member in about a year - and
that one (grebe) ran 5.1 using gcc.

The link you provided is a subsection of the general installation notes:

http://www.postgresql.org/docs/9.2/interactive/installation.html

Have you read this entire chapter and tried to follow the instructions?

Hopefully someone has, and ideally is willing to contribute to the
documentation or Wiki, a cookbook recipe if indeed the process is
considerably different that what is already documented in the aforementioned
chapter.

David J.




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

This email and any files transmitted with it are confidential, proprietary and intended solely for the individual or entity to whom they are addressed. If you have received this email in error please delete it immediately.

Thank you for your response. If you or someone can provide steps on how to bundle PostgreSQL on AIX (using IBM XL C compiler), that would be great so I can try it out to see if works for AIX 7 platform. I’m new to AIX platform and appreciate any help that you can provide.

these are some notes on how I built pg 9.1 for AIX 6.1.  the process should be virtually identical for newer versions of either PG or AIX.   Note I don't build a lot of the optional features as we don't use them (plperl, plpython, the contrib modules, etc)

Prerequisites

to build or run

1. IBM Power6 or newer server
2. IBM AIX 6.1
3. IBM XLC 11 or 12 (only needed to build)
4. create a postgres user account and directories

   mkuser postgres mkdir -p /opt/pgsql91    # postgres software directory. mkdir -p /u10/pgsql91    # postgres database directories will go here chown -R postgres /u10/pgsql91 /opt/pgsql91

5. postgres user environment as follows ...
   /home/postgres/.profile

   export PATH=/usr/bin:/usr/ucb:$HOME/bin:/opt/pgsql91/bin:/usr/sfw/bin export PGDATA=/u10/pgsql91/data

we use some utils from the IBM AIX Linux Toolkit, including gtar, gmake, and wget.

Build

initialize the database...

Configure

edit $PGDATA/pg_hba.conf

edit $PGDATA/postgresql.conf and find/set the following. some are # commented, some aren't, be sure to delete the # if you edit a value...

The values should be adjusted to suit the application. shared_buffers usually should be no more than 2GB even on very large systems. adjust the work_mem down if you expect a large number of concurrent queries as this can be allocated several times for a complex query.

Run

as postgres...

Admin

as postgres...

autostart

create /etc/rc.d/init.d/postgres91

as root...

To start postgres, as root...

or stop or restart or reload

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