PostgreSQL: Installation

I have installed PostgreSQL 9.0.4 in Sun Solaris platform. The installation steps are as below:

11.      Download binary (you can also install PostgreSQL from source)

  http://www.postgresql.org/ftp/binary/v9.0.4/solaris/solaris10/sparc/

  or    postgresql-9.0.4-S10.sparc-64.tar.bz2

  or    http://www.postgresql.org/download/  -> Downloads  -> Solaris  -> download  -> v9.0.4  ->    

         solaris -> solaris10  -> sparc  -> postgresql-9.0.4-S10.sparc-64.tar.bz2 

22.      Create an OS user (here postgresql, you can use any name, better to use group)

33.      create a directory: /u01/postgres and copy the binary here

44.      bunzip2 < postgresql-9.0.4-S10.sparc-64.tar.bz2 | tar xpf -

55      -bash-3.00$ echo $PATH

  /usr/bin:/opt/EMCpower/bin:/etc/emc/bin:/etc

 Add “/u01/postgres/postgres/9.0-pgdg/bin/64” infront of “/usr/bin”

 -bash-3.00$ export PATH=/u01/postgres/postgres/9.0-  

   pgdg/bin/64:/usr/bin:/opt/EMCpower/bin:/etc/emc/bin:/etc

  -bash-3.00$ echo $PATH

   /u01/postgres/postgres/9.0-pgdg/bin/64:/usr/bin:/opt/EMCpower/bin:/etc/emc/bin:/etc

  -bash-3.00$

Important:

Make sure (install dir) /u01/postgres/postgres/9.0-pgdg/bin is in your PATH *before* /usr/bin, otherwise default directories of  PostgreSQL 8.1 binaries will be invoked and used.

If you install the 64bit package, these files will install in subdirectories bin/64 and lib/64 rather than bin and lib; adjust your PATH accordingly.  This also means that it's possible to install both 32 bit and 64 bit PostgreSQL on the same system.