confluence db in postgres

[Padmasree P]

how do we create confluence db with postgres character encoding and collation set to utf8

I'm following this document for setting up postgres db . 

https://confluence.atlassian.com/conf67/database-setup-for-postgresql-945103516.html

will this command work 

CREATE DATABASE "confluence_db"
WITH OWNER "postgres"
ENCODING 'UTF8'
LC_COLLATE = 'en_US.UTF-8'
LC_CTYPE = 'en_US.UTF-8'
TEMPLATE template0;

[Yogesh Mude]

HI @Padmasree P

Use the below command..

CREATE DATABASE confluencedb WITH OWNER = CONFLUENCE_DB ENCODING 'UNICODE' LC_COLLATE 'C' LC_CTYPE 'C' TEMPLATE template0;

[Padmasree P]

Hi Yohesh,

I need the db to have encoding and collation set to utf8 . not c collation. please help with utf8 command

[Yogesh Mude]

Are you using Windows/Linux?

Please have a look at the below answer.

https://community.atlassian.com/t5/Confluence-questions/Setting-up-Postgresql-database-for-Confluence/qaq-p/759168

[Padmasree P]

I'm using Linux, is this link for Linux?

[Yogesh Mude]

Yes.

[Robert Horan]

@Yogesh Mude - this link just saved me a LOT of time.   I wish this was part of the official documentation.  You have my deepest thanks.