Setting up Postgresql database for Confluence

[Thomas Hsieh]

Hi,

I'm new to Postgresql and Confluence, and I'm trying to setup the database (I have the on-premise server version) by following this guide:

https://confluence.atlassian.com/doc/database-setup-for-postgresql-173244522.html

At step 2.2, it states that "Collation must also be set to utf8", but how exactly do I do that? I'm assuming it's the LC_COLLATE option, and I've tried 'UTF-8', 'UTF8', 'en_US.utf8', and 'en_US.UTF-8', none of which worked.

Any help is appreciated, thanks!

[Dave Chevell]

Just noting that this is a duplicate of this question: https://community.atlassian.com/t5/Confluence-questions/Setting-up-Postgresql-database-for-Confluence/qaq-p/759168#U759182

Any answers should be directed there

[Thomas Hsieh]

Sorry I think I posted twice by mistake.

Could you delete this question or close it, if possible?

Thank you!