These are the instructions on how to access PostgreSQL database.

MACHINE

Currently the PostgreSQL database server is running on the new linux 
cluster server shown below:

	IP:	   128.8.126.132
	hostname:  squeamish.csic.cs.umd.edu

You should log in this server before you can use the database. Make sure 
you change your password after the first login and remember the new password.

Note:
After re-type your new password, you may possiblely meet an error message like this one:

      "Could not chdir to home directory /afs/csic/class/cmsc424/0101/cs424060: Permission denied."

You could just terminate the current session by Ctrl+C and log in again use the *new*
password. It should be OK then.

POSTGRESQL ACCOUNT and PASSWORDS

Your PostgreSQL account name and password are the same as your Linux cluster
account name and *original* Linux cluster password given to you in the class.

You should note that a change of Linux password does not imply
a change in your PostgreSQL password and vice versa. These are
independently controlled with only initial values being equal.


DATABASE ACCESS

Psql is the command that you will use to access PostgreSQL server.
Psql is a client application that will try to connect to the server.
It will ask you for password, and you will use the same password
given to you for Oracle account.

Use "man psql" for more details.


EXAMPLE SESSION

If you have your database (not unix!) username cs424060,
then, the following would be a sample session that list sql commands 
for which there is available help.

[cs424060@squeamish ~]$ psql
Password: 
Welcome to psql, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help on internal slash commands
       \g or terminate with semicolon to execute query
       \q to quit

cs424060=> \h
Available help:
  ABORT                     CREATE TABLE AS           FETCH                     
  ALTER GROUP               CREATE TRIGGER            GRANT                     
  ALTER TABLE               CREATE TYPE               INSERT                    
  ALTER USER                CREATE USER               LISTEN                    
  ANALYZE                   CREATE VIEW               LOAD                      
  BEGIN                     DECLARE                   LOCK                      
  CHECKPOINT                DELETE                    MOVE                      
  CLOSE                     DROP AGGREGATE            NOTIFY                    
  CLUSTER                   DROP DATABASE             REINDEX                   
  COMMENT                   DROP FUNCTION             RESET                     
  COMMIT                    DROP GROUP                REVOKE                    
  COPY                      DROP INDEX                ROLLBACK                  
  CREATE AGGREGATE          DROP LANGUAGE             SELECT                    
  CREATE CONSTRAINT TRIGGER DROP OPERATOR             SELECT INTO               
  CREATE DATABASE           DROP RULE                 SET                       
  CREATE FUNCTION           DROP SEQUENCE             SET CONSTRAINTS           
  CREATE GROUP              DROP TABLE                SET SESSION AUTHORIZATION 
  CREATE INDEX              DROP TRIGGER              SET TRANSACTION           
  CREATE LANGUAGE           DROP TYPE                 SHOW                      
  CREATE OPERATOR           DROP USER                 TRUNCATE                  
  CREATE RULE               DROP VIEW                 UNLISTEN                  
  CREATE SEQUENCE           END                       UPDATE                    
  CREATE TABLE              EXPLAIN                   VACUUM                    
cs424060=> \q
[cs424060@squeamish ~]$