...
Create the confluence database admin account by typing in these commands,.
| Note |
|---|
Make sure to change putYourPasswordHere to a secure password. |
| Code Block |
|---|
|
CREATE ROLE confluencedbuser LOGIN ENCRYPTED PASSWORD 'putYourPasswordHere'
NOINHERIT
VALID UNTIL 'infinity';
COMMENT ON ROLE confluencedbuser IS 'Account used by the Confluence application.'; |
The servers will respond to each respective command,
| Code Block |
|---|
|
CREATE ROLE
COMMENT |
Create the database.
| Code Block |
|---|
|
CREATE DATABASE confluencedb
WITH ENCODING='UTF8'
OWNER=confluencedbuser
CONNECTION LIMIT=-1; |
If all goes well the response will be,
| Code Block |
|---|
|
CREATE DATABASE |
Finally quit the PostgreSQL prompt,
...