Project

General

Profile

1
Instructions on initially creating the workflow scheduler database.
2

    
3
Update postgres configuration
4
	Edit:
5
		/etc/postgresql/<postgres_version>/main/pg_hba.conf
6
	Add the following Line:
7
		host workflowscheduler workflowscheduler 127.0.0.1 255.255.255.255 password
8
		
9
Create database:
10
	type: createdb workflowscheduler
11
	
12
Create workflowscheduler user
13
	Log in to postgreSQL by typing: 
14
		psql workflowscheduler
15
	At the psql prompt, create the workflowscheduler user by typing:
16
		CREATE USER workflowscheduler WITH UNENCRYPTED PASSWORD 'your_password';
17
    where 'your_password' is whatever password you would like for the workflowscheduler user.
18
	Exit PostgreSQL by typing:
19
		\q
20
	Restart the PostgreSQL database to bring in changes:
21
     	/etc/init.d/postgresql-8.3 restart
22
     	
23
Test setup
24
	Log out of the postgres user account by typing:
25
		logout
26
	Test the installation and workflowscheduler account by typing:
27
		psql -U workflowscheduler -W -h localhost workflowscheduler
28
		
29
Create tables:
30
	Open the table creation script at:
31
		<metacat>/src/scripts/workflowscheduler-db-scripts/ws-tables-postgres.sql
32
	Copy each sql command and run in psql prompt.
33
	
34
Populate tables
35
	Open the table creation script at:
36
		<metacat>/src/scripts/workflowscheduler-db-scripts/ws-loaddtdschema-postgres.sql
37
	Copy each sql command and run in psql prompt.
38
		
(1-1/2)