PostgreSQL is a sophisticated Object-Relational DBMS, supporting almost all SQL constructs, including subselects, transactions, and user-defined types and functions. The PostgreSQL home page has more information and documentation.
postgresql-7.0.3: description + notes
NOTE: Some manual configuration steps are necessary before you can use this product. See
/usr/freeware/doc/postgres/admin/install855.htmfor complete instructions, but at a minimum you must:
- Create a non-privileged user account (perhaps "
postgres") to own the database files.- Dump (with pg_dumpall) any existing database before installing this package, and then halt the database server and rename the old database directory.
- As the database user create a data directory and run "initdb -D ..." to initialize it. (Replace "
..." with the full path name of the new directory.)- Start postmaster, the database server, as directed by
initdbin the previous step.- Reload your old data if appropriate.
- Arrange to have postmaster started automatically at boot time. postmaster should only be run by the database user, not by
root. A template/etc/init.d/postgresfile has been included. After customizing it you may find it useful.This package includes optional subsys for
tclandodbcinterfaces.NOTE: This package was built with the MipsPRO 7.3 compilers. If you are running on IRIX 6.5.9 or earlier you must install the following patches (or their successors):Patches can be downloaded from http://www.sgi.com/support/patch_intro.html
- patch 3742 (5 MB) -- c++_eoe (includes libCio.so)
- patch 3911 (19 MB) -- compiler_eoe (except libmp)
To auto-install this package, go back and click on the respective install icon.