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.3.2: description + notes
NOTE: Some manual configuration steps are necessary before you can use this product. See /usr/freeware/doc/postgresql/html/installation.html for 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
initdb
in 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/fw_postgres
file has been included. After customizing it you may find it useful.This package includes optional subsys for
tcl
andperl
interfaces.
To auto-install this package, go back and click on the respective install icon.