createWorkflowSchedulerDB.txt

Instructions on initially creating the workflow scheduler database.

Update postgres configuration
	Edit:
		/etc/postgresql/<postgres_version>/main/pg_hba.conf
	Add the following Line:
		host workflowscheduler workflowscheduler 127.0.0.1 255.255.255.255 password
		
Create database:
	type: createdb workflowscheduler
	
Create workflowscheduler user
	Log in to postgreSQL by typing: 
		psql workflowscheduler
	At the psql prompt, create the workflowscheduler user by typing:
		CREATE USER workflowscheduler WITH UNENCRYPTED PASSWORD 'your_password';
    where 'your_password' is whatever password you would like for the workflowscheduler user.
	Exit PostgreSQL by typing:
		\q
	Restart the PostgreSQL database to bring in changes:
     	/etc/init.d/postgresql-8.3 restart
     	
Test setup
	Log out of the postgres user account by typing:
		logout
	Test the installation and workflowscheduler account by typing:
		psql -U workflowscheduler -W -h localhost workflowscheduler
		
Create tables:
	Open the table creation script at:
		<metacat>/src/scripts/workflowscheduler-db-scripts/ws-tables-postgres.sql
	Copy each sql command and run in psql prompt.

        Or at the psql prompt, type "\i <metacat>/src/scripts/workflowscheduler-db-scripts/ws-tables-postgres.sql"
	
Populate tables
	Open the table creation script at:
		<metacat>/src/scripts/workflowscheduler-db-scripts/ws-loaddtdschema-postgres.sql
	Copy each sql command and run in psql prompt.
	
	Or  at the psql prompt, type "\i  <metacat>/src/scripts/workflowscheduler-db-scripts/ws-loaddtdschema-postgres.sql"