Create Workflow Scheduler Database |
Instructions on initially creating the workflow scheduler database.
Update postgres configuration
/etc/postgresql//main/pg_hba.conf
host workflowscheduler workflowscheduler 127.0.0.1 255.255.255.255 password
Create database:
createdb workflowscheduler
Create workflowscheduler user
psql workflowscheduler
CREATE USER workflowscheduler WITH UNENCRYPTED PASSWORD 'your_password';
\q
/etc/init.d/postgresql-8.3 restart
Test setup
logout
psql -U workflowscheduler -W -h localhost workflowscheduler
Create tables:
/src/scripts/workflowscheduler-db-scripts/ws-tables-postgres.sql
/src/scripts/workflowscheduler-db-scripts/ws-tables-postgres.sql
Populate tables
/src/scripts/workflowscheduler-db-scripts/ws-loaddtdschema-postgres.sql
/src/scripts/workflowscheduler-db-scripts/ws-loaddtdschema-postgres.sql