commit b755906ad165fea4e56176ff3a1c3f9ef09150a9 parent 847a466417a4a796beb7af955b768135a1a4a489 Author: Lukáš Zapletal <lzap+git@redhat.com> Date: Fri, 11 Nov 2022 09:42:04 +0100 [docs] postgres collation warning (#1017) Diffstat:
| M | .gitignore | | | 4 | ++++ |
| M | docs/configuration/database.md | | | 4 | +++- |
2 files changed, 7 insertions(+), 1 deletion(-)
diff --git a/.gitignore b/.gitignore @@ -32,3 +32,7 @@ shell.nix # ignore custom GOBIN path /bin + +# ignore config dirs from IDEs +/.idea/ +/.fleet/ diff --git 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