Skip to content

Instantly share code, notes, and snippets.

@dbrownidau

dbrownidau/run.sql

Last active May 6, 2019 02:29
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save dbrownidau/fe5083991b4e65a352262e2768b84de7 to your computer and use it in GitHub Desktop.
Save dbrownidau/fe5083991b4e65a352262e2768b84de7 to your computer and use it in GitHub Desktop.
Download ZIP
Confluence database encoding & collation setup (Postgresql)
Raw
run.sql
# As of Confluence 6.15 please use char encoding UTF-8
# WARN: Collations, such as "C", are known to cause issues with Confluence.
# https://confluence.atlassian.com/doc/database-setup-for-postgresql-173244522.html
# Ommitting collation settings will cause the system to default to current locale.
# If you force " LC_COLLATE = 'en_US.UTF-8' " and the system local is not en_US, errors will occure.
create database confluence with owner confluence ENCODING 'utf-8';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment