Building Java Enterprise Applications

PostgreSQL

PostgreSQL, along with mySQL, is a popular open source option for Unix-flavored systems like Linux, Solaris, and my own Mac OS X. You can download the distribution from http://www.postgresql.org (for U.S. users, the best mirror site is http://www.us.postgresql.org). Installation instructions are included in the distribution and are also available at the web site. Install the database and then start it as shown here:

[localhost:~] postgres% /usr/local/pgsql/bin/postmaster -D /usr/local/pqsql/data

Once you’ve got the database running, presumably with the “postgres” user (as the installation instructions recommend), you need to create the Forethought database:

[localhost:~] postgres% /usr/local/pgsql/bin/createdb forethought
CREATE DATABASE

The next step is to connect to the database and run your SQL scripts against it. This is done with the psql tool, a handy utility for just this purpose. Run this script, specifying the database to connect to and the file with SQL to execute:

[localhost:~] postgres% psql -f database_schema_users.sql forethought NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index 'user_types_pkey' for table 'user_types' psql:database_schema_users.sql:5: NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index 'user_types_pkey' for table 'user_types' CREATE NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index 'offices_pkey' for table 'offices' psql:database_schema_users.sql:12: NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index ...