Search Postgresql Archives

Re: did freese in creating a database cluster

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 12/27/10 6:21 PM, Tsutomu Nakajima wrote:
>  <<System>>
>  PostGreSQL: 7.4.30 the postgres-installer ( postgresql-7.4.30.tar.gz)
>  OS: AIXv5.2 TL09 (POWER5)
>  Machine: 9119-590(1LPAR)

as others have said, 7.4 is really really old and completely at end of life, and should certainly not be used for new projects.

I have had no problems building and running PostgreSQL 8.4.5 on AIX 5.3L and 6.1, on Power 5 and 6 gear, using IBM XL C for AIX v11.1

to build 8.4, I first built zlib 1.2.5 and readline 6.1 as static libraries, built in my compile user's $HOME/src/* tree.

my build environment is...

export PATH=/usr/bin:/etc:/usr/sbin:/usr/ucb:/home/postgres/bin:/usr/bin/X11:/sbin
  export CC=/usr/vacpp/bin/xlc


zlib build:
$ CFLAGS="-q64" AR="/usr/bin/ar -X64" ./configure --prefix=$HOME/src --64 --static && gmake && gmake install

readline build:
$ CC=/usr/vacpp/bin/xlc CFLAGS="-q64 -I$HOME/src/include" LDFLAGS="-L$HOME/src/lib" AR="/usr/bin/ar" ./configure --prefix=$HOME/src && gmake && gmake install

then I built postgres via...
$ 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/pgsql84 && gmake && gmake test && sudo gmake install



then, as the postgres user, I setup...

$ export PGDATA=/u10/pgsql/data
$ export PATH=/usr/bin:/etc:/usr/sbin:/usr/ucb:/home/postgres/bin:/usr/bin/X11:/sbin:/opt/pgsql84/bin

(I have the above in the PG user's .profile, actually)

$ initdb -E UTF8

and it ran in at most a couple seconds on a Power 520.




--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux