Chapter 2. Administrator
Administrator is a graphical database administration tool. It is designed to help Database Administrators (DBAs) perform administrative tasks such as creating databases, tables, indexes, and so on; edit privileges; and manage users and groups. Activities such as working with queries and performing data inserts and deletes are data-level tasks; Administrator is not designed for such tasks.
 | Note |
|---|---|
The text in the Administrator chapters is more current than the screen captures. Where the text differs from the screen captures, follow the text. |
Administrator supports operations on:
| aggregates | casts | columns |
| constraints | conversions | databases |
| data types | domains | functions |
| groups | indexes | languages |
| operators | operator classes | rules |
| schemas | sequences | tables |
| triggers | users | views |
2.1. Administrator Prerequisites
Before you run Administrator, ensure that your system has the prerequisite software and configuration.
To run Administrator you must have a Java2 Runtime Environment (JRE) of version 1.3 or greater installed (1.4.1 or greater is recommended).
Administrator also requires that the PostgreSQL - Red Hat Edition JDBC driver package (rh-postgresql-jdbc) be installed.
The JAVA_HOME environment variable must point to the desired Java JRE. You must make sure that the java command returned by which java is the one from the same JRE. There may be other java commands in your path, so you need to make sure that the correct bin JRE subdirectory is ahead of any others in your PATH environment variable. In particular, a /usr/bin/java path may exist that uses the GNU Java runtime, not the Sun or IBM ones.
If your database server has the rh-postgresql-test package installed and you have run the regression tests, you can perform the examples that appear later in this chapter. If it has not been installed, you might want to install it now and then run the regression tests. (Refer to Section 7.18 Running Regression Tests on a Database Cluster.)