...
Create the confluence database admin account by typing in these commands,
| No Format |
|---|
CREATE ROLE confluencedbuser LOGIN ENCRYPTED PASSWORD 'putYourPasswordHere' |
...
NOINHERIT |
...
VALID UNTIL 'infinity'; |
...
COMMENT ON ROLE confluencedbuser IS 'Account used by the Confluence application.'; |
Create the database.
| No Format |
|---|
CREATE DATABASE confluencedb |
...
WITH ENCODING='UTF8' |
...
OWNER=confluencedbuser |
...
CONNECTION LIMIT=-1; |
| Note |
|---|
I changed the name used The name of the database is different than in the confluence documentation from confluence to confluencedb. As a coder it will be easier for me later one. Rather than the database name confluence, we use confluencedb to clearly designate a database. |
Confluence 3.2 does include a JDBC driver for PostgreSQL. However, because we are using the newest Java download the JDBC4 driver from the PostgreSQL website.
...