-= PostgreSQL Installation Instructions =-

These instructions make the assumption that you are already well aware
on how to install and configure PostgreSQL.    If you have never had the
opportunity to configure Postgre, we would recommend the one visits the
following site for documentation of information to proceed: 
http://www.postgresql.org/

Since version 1.2.0 of Ethereal Realms, the use of Database dumps were
put into use instead of a long complicated configuration script that
will only see use once.   Not only does this allow for an exact snapshot
of the database schemia, but makes use of existing restoration tools 
which allow for less opportunity of failure. 

The ./postgres directory contains the following files:
   ethereal-schema.sql
   ethereal-functions.sql
   ethereal-data.sql

In order to 'recover' the database for use with Ethereal, you will need
to make use of one tool which is included with a normal install of
PostgreSQL.  Please note, this makes the assumption that the postmaster
daemon is running and you have a user capable of creating new users and
schemas.    If this has yet to have been done, please consult
PostgreSQL documentation.

These instructions make use of the default database ethereal, which has
been configured to PG/PLSQL functions.  The superuser of postgres has
also been chosen as a default which is generally created by default when
installing the database using packages.

The username needed to perform these tasks may be different depending on
your access, which implies the switches may need to change in order to
function as intended.   If the database is used on a multiuser system,
please consult your Systems administrator.

Once this has been done the following commands can be issued to get
things up and running on the database side:

 cd [location of psql]
 ./psql -h myhost -U postgres -f [path]/mysql/ethereal-schema.sql ethereal
  (Lines will be passing by)
 ./psql -h myhost -U postgres -f [path]/mysql/ethereal-functions.sql ethereal
  (Lines will be passing by)
 ./psql -h myhost -U postgres -f [path]/mysql/ethereal-data.sql ethereal
  (Lines will be passing by) 

NOTE: If you cannot make use of the ethereal user as used in the system.
You will need to rename the instances of the name ethereal within the 
schema, functions and data files as to match the username you WILL be
using. 
need 
