Metacat

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:

Create workflowscheduler user

	Log in to postgreSQL 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:

		<metacat>/src/scripts/workflowscheduler-db-scripts/ws-tables-postgres.sql

Populate tables

		<metacat>/src/scripts/workflowscheduler-db-scripts/ws-loaddtdschema-postgres.sql