1 |
5138
|
daigle
|
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 |
5179
|
leinfelder
|
type: createdb workflowscheduler
|
11 |
5138
|
daigle
|
|
12 |
|
|
Create workflowscheduler user
|
13 |
|
|
Log in to postgreSQL by typing:
|
14 |
5179
|
leinfelder
|
psql workflowscheduler
|
15 |
5138
|
daigle
|
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 |
5153
|
daigle
|
Open the table creation script at:
|
31 |
|
|
<metacat>/src/scripts/workflowscheduler-db-scripts/ws-tables-postgres.sql
|
32 |
5138
|
daigle
|
Copy each sql command and run in psql prompt.
|
33 |
5311
|
daigle
|
|
34 |
|
|
Or at the psql prompt, type "\i <metacat>/src/scripts/workflowscheduler-db-scripts/ws-tables-postgres.sql"
|
35 |
5138
|
daigle
|
|
36 |
|
|
Populate tables
|
37 |
5153
|
daigle
|
Open the table creation script at:
|
38 |
|
|
<metacat>/src/scripts/workflowscheduler-db-scripts/ws-loaddtdschema-postgres.sql
|
39 |
5138
|
daigle
|
Copy each sql command and run in psql prompt.
|
40 |
5311
|
daigle
|
|
41 |
|
|
Or at the psql prompt, type "\i <metacat>/src/scripts/workflowscheduler-db-scripts/ws-loaddtdschema-postgres.sql"
|