diff options
author | 2023-08-06 11:54:07 +0200 | |
---|---|---|
committer | 2023-08-06 11:54:07 +0200 | |
commit | 7f1f2b80eab3bb5f357b22717ca08a464c69245a (patch) | |
tree | d0dc5a44a69348ff6d3e2c4d4d5758ece802c2ec | |
parent | [performance] add caching of status fave, boost of, in reply to ID lists (#2060) (diff) | |
download | gotosocial-7f1f2b80eab3bb5f357b22717ca08a464c69245a.tar.xz |
[docs] fix postgres create database command (#2071)
The current command `create database gotosocial with locale C.UTF-8 template template0;` fails because the locale has to be quoted:
```
postgres=# create database gotosocial with locale C.UTF-8 template template0;
ERROR: syntax error at or near "."
LINE 1: create database gotosocial with locale C.UTF-8 template temp...
```
Tested manually that it works with the quotes and the official postgres examples also use quotes around the locales: https://www.postgresql.org/docs/current/sql-createdatabase.html
-rw-r--r-- | docs/configuration/database.md | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/docs/configuration/database.md b/docs/configuration/database.md index 3e66b09fc..294420a36 100644 --- a/docs/configuration/database.md +++ b/docs/configuration/database.md @@ -37,7 +37,7 @@ 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 with locale C.UTF-8 template template0; +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; ``` |