diff options
| author |  Lukáš Zapletal <lzap+git@redhat.com> | 2022-11-11 09:42:04 +0100 |
|---|---|---|
| committer |  GitHub <noreply@github.com> | 2022-11-11 09:42:04 +0100 |
| commit | b755906ad165fea4e56176ff3a1c3f9ef09150a9 (patch) | |
| tree | f7e40d3c8957e460600b537143a3699beb1d9733 /docs/configuration/database.md | |
| parent | [docs] Replace old references to the previous streaming with websockets (#1015) (diff) | |
| download | gotosocial-b755906ad165fea4e56176ff3a1c3f9ef09150a9.tar.xz | |
[docs] postgres collation warning (#1017)
Diffstat (limited to 'docs/configuration/database.md')
| -rw-r--r-- | docs/configuration/database.md | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/docs/configuration/database.md b/docs/configuration/database.md index a8d7645e2..336279967 100644 --- a/docs/configuration/database.md +++ b/docs/configuration/database.md @@ -37,11 +37,13 @@ Then you should have already created database `gotosocial` in Postgres, and give The psql commands to do this will look something like: ```psql -create database gotosocial; +create database gotosocial with locale C.UTF-8 template template0; create user gotosocial with password 'some_really_good_password'; grant all privileges on database gotosocial to gotosocial; ``` +GoToSocial makes use of ULIDs (Universally Unique Lexicographically Sortable Identifiers) which will not work in non-English collate environments. For this reason it is important to create the database with `C.UTF-8` locale. To do that on systems which were already initialized with non-C locale, `template0` pristine database template must be used. + ## Settings ```yaml |