Chapter 2. Installing GUS

Table of Contents

System Requirements
Hardware
Software
Preparing the RDBMS System
Downloading GUS
Configuring and Preparing GUS
Installing GUS
Post-Installation Setup
Database Privileges and Roles
Registering the GUS Application Framework
Creating users, groups, and projects
Reinstalling the GUS Application Framework

System Requirements

Hardware

While the GUS Application framework has primarily been developed on Linux, it should in principle run on any UNIX-based operating system, including Mac OS X, provided the software requirements below can be satisfied.

Note

Users have reported difficulty running GUS on Solaris.

As noted below, GUS requires the use of either Oracle or PostgreSQL as a relational database management system (RDBMS). PostgreSQL support is much more recent, and as such, Oracle is recommended whenever practical. For installations with more than 3-5GB of data, Oracle is highly recommended. PostgreSQL, however, is an open source and freely available database system, and thus makes an attractive option for smaller GUS installations, or where Oracle is not economical. The choice of an RDBMS will affect your system and hardware requirements. Refer to you RDBMS's documentation for further details and specific requirements.

GUS's hardware requirements depend largely on the size and complexity of the data you intend to load and analyze using GUS. Most installations will have a separate server for the database management system, for which you should refer to your RDBMS's documentation for requirements. For the GUS Application framework, any modern desktop PC satisfying the above architecture requirements should suffice. A 2.4Ghz Pentium with 512MB of RAM (or equivalent machine) would serve as a good basic machine. For parsing large datafiles, a 3.2Ghz Pentium with as much as 4GB of RAM may be more appropriate. For guidance specific to your situation, refer to the mailing list archives or post a new message to the list.

Software

GUS requires the following third party software packages:

Preparing the RDBMS System

Note

If the GUS Schema has already been installed in the RDBMS, you may skip this step and proceed directly to the section called “Downloading GUS”

Once you've satisfied the above software requirements and installed and configured your database system, you should create or identify an existing database to install GUS into. As part of this process, more advanced users of GUS may consider tuning various database settings such as a data block size and memory allocations, as well as custom tablespace creation. Many of these settings will vary greatly depending on your usage of GUS and database system; refer to your RDBMS's documentation for further details and options.

Once the database to hold GUS has been created and configured, you must create or identify a user that the GUS installer will use to install the GUS Schema. When using Oracle, this user should be granted the create session and dba privileges for the duration of the install (after installation these privileges may be revoked). For PostgreSQL, it is recommended that this user be the owner of the database or be granted all privileges on all objects within the database. For both database systems, the installer will connect as this user, and as this user create the necessary schemata, tables, sequences, indexes, constraints, and the other objects that compose GUS.

Important

If you are using Oracle, you must set the NLS_DATE_FORMAT to YYYY-MM-DD HH24:MI:SS