...
First log into the PostgreSQL prompt as explain in PostgreSQL on Ubuntu|wiki/display/bonsai/6.0+PostgreSQL|\.
Create the confluence database admin account,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.
CREATE DATABASE confluencedb
WITH ENCODING='UTF8'
OWNER=confluencedbuser
CONNECTION LIMIT=-1;
...