I have followed the steps from the below link but no luck! https://confluence.atlassian.com/doc/database-setup-for-postgresql-173244522.html
below is the my create database script and the database created successfully:
CREATE DATABASE "CONF-DB" WITH OWNER = "CONF_USER" ENCODING 'UTF8' LC_COLLATE = 'English_United States.1252' LC_CTYPE = 'English_United States.1252' TEMPLATE template0;
but if i use following script to create database into postgres it fails:
CREATE DATABASE "CONF-DB" WITH OWNER = "CONF_USER" ENCODING 'UTF8' LC_COLLATE = 'UTF8' LC_CTYPE = 'UTF8' TEMPLATE template0;
2021-06-19 00:10:24,569 INFO [Catalina-utility-1] [com.atlassian.confluence.lifecycle] contextInitialized Starting Confluence 6.15.8 [build 8100 based on commit hash 6ef1ce95c788ac159314a8fa6387047b8d1cc9fb] - synchrony version 2.1.0-release-confluence_6.15-32f7299a
2021-06-19 00:10:30,969 INFO [Catalina-utility-1] [springframework.web.context.ContextLoader] initWebApplicationContext Root WebApplicationContext: initialization started
2021-06-19 00:10:37,938 INFO [Catalina-utility-1] [com.atlassian.confluence.lifecycle] <init> Loading EhCache cache manager
2021-06-19 00:11:07,143 INFO [Catalina-utility-1] [springframework.web.context.ContextLoader] initWebApplicationContext Root WebApplicationContext: initialization completed in 36173 ms
2021-06-19 00:11:08,302 ERROR [Catalina-utility-1] [atlassian.confluence.setup.DefaultDatabaseVerifier] verifyCollationOfDatabase The collation of database is not set correctly!
2021-06-19 00:11:08,992 WARN [Catalina-utility-1] [confluence.impl.health.DefaultHealthCheckRunner] logEvent The database collation 'English_United States.1252' is not supported by Confluence. You need to use 'utf-8'.
2021-06-19 00:11:08,993 WARN [Catalina-utility-1] [confluence.impl.health.DefaultHealthCheckRunner] logEvent The database collation 'English_United States.1252' is not supported by Confluence. You need to use 'utf-8'.
