Page History
...
The following outlines the steps to take when creating the user accounts in your PostgreSQL database.
indent | ||
---|---|---|
| ||
1. Log into PostgreSQL using psql. $ su - postgres
$ psql |
indent | ||
---|---|---|
| ||
2. Create the following databases: |
indent | ||
---|---|---|
| ||
|
...
i2b2demodata
...
i2b2hive
...
i2b2imdata
...
i2b2metadata
...
i2b2pm
...
i2b2workdata
|
indent | ||
---|---|---|
| ||
Example Command to create a database |
indent | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| |||||||||||||
|
...
|
indent | ||
---|---|---|
| ||
3. Create the following users: CREATE USER i2b2demodata WITH PASSWORD ' |
...
demouser' ; |
Grant all the privileges on the database
GRANT ALL PRIVILEGES ON DATABASE i2b2demodata to i2b2demodata;
...
Level | 3 |
---|
...
User Name
...
Password
...
Database
...
i2b2demodata
...
demouser
...
i2b2demodata
...
i2b2hive
...
demouser
...
i2b2hive
...
i2b2imdata
...
demouser
...
i2b2imdata
...
i2b2metadata
...
demouser
...
i2b2metadata
...
i2b2pm
...
demouser
...
i2b2pm
...
i2b2workdata
...
demouser
...
CREATE USER i2b2hive WITH PASSWORD 'demouser' ; Create the Schema's CREATE SCHEMA i2b2demodata AUTHORIZATION i2b2demodata ; |
Note | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
| |||||||||||
|