coop-cloud/matrix-synapse
coop-cloud/matrix-synapse
4
0
Fork 2
Code Issues 4 Pull Requests 1 Releases Wiki Activity

v13 postgres broken on new install #23

New Issue
Closed
opened 2022-03-07 18:42:11 +00:00 by decentral1se · 2 comments
decentral1se commented 2022-03-07 18:42:11 +00:00
Owner
Copy Link
> The database cluster will be initialized with locale "en_US.utf8".
> initdb: error: "UTF-8 --lc-collate=C --lc-ctype=C" is not a valid server encoding name

compose.yml Line 62 in 1188f5d770
- POSTGRES_INITDB_ARGS="--encoding=UTF-8 --lc-collate=C --lc-ctype=C"

args must have changed in between minor versions?

Taken originally from https://github.com/matrix-org/synapse/blob/develop/contrib/docker/docker-compose.yml

``` > The database cluster will be initialized with locale "en_US.utf8". > initdb: error: "UTF-8 --lc-collate=C --lc-ctype=C" is not a valid server encoding name ``` https://git.coopcloud.tech/coop-cloud/matrix-synapse/src/commit/1188f5d77004c7b32f99838b59e8b3128cf4a909/compose.yml#L62 args must have changed in between minor versions? Taken originally from https://github.com/matrix-org/synapse/blob/develop/contrib/docker/docker-compose.yml
decentral1se commented 2022-03-07 18:51:51 +00:00
Author
Owner
Copy Link

Oh dear dog https://github.com/docker-library/postgres/issues/840

Oh dear dog https://github.com/docker-library/postgres/issues/840
decentral1se commented 2022-03-07 18:57:19 +00:00
Author
Owner
Copy Link
diff --git a/compose.yml b/compose.yml
index b904454..d560d02 100644
--- a/compose.yml
+++ b/compose.yml
@@ -59,7 +59,9 @@ services:
       - db_password
     environment:
       - POSTGRES_DB=synapse
-      - POSTGRES_INITDB_ARGS="--encoding=UTF-8 --lc-collate=C --lc-ctype=C"
+      - POSTGRES_INITDB_ARGS="-E \"UTF8\""
+      - LC_COLLATE=C
+      - LC_CTYPE=C
       - POSTGRES_PASSWORD_FILE=/run/secrets/db_password
       - POSTGRES_USER=synapse
     networks:
```diff diff --git a/compose.yml b/compose.yml index b904454..d560d02 100644 --- a/compose.yml +++ b/compose.yml @@ -59,7 +59,9 @@ services: - db_password environment: - POSTGRES_DB=synapse - - POSTGRES_INITDB_ARGS="--encoding=UTF-8 --lc-collate=C --lc-ctype=C" + - POSTGRES_INITDB_ARGS="-E \"UTF8\"" + - LC_COLLATE=C + - LC_CTYPE=C - POSTGRES_PASSWORD_FILE=/run/secrets/db_password - POSTGRES_USER=synapse networks: ```
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
No items
No Label
Milestone
No items
No Milestone
Assignees
Clear assignees
3wordchant aadil abra-bot ammaratef45 Apfelwurm appletalk arjan basebuilder Brooke carla cas codegod100 coopcloud decentral1se fauno flancian Frando iexos javielico kawaiipunk knoflook lambdabundesverband mac-chaffee marlon mayel mirsal moritz nicksellen notplants p4u1 pau renovate-bot rix sef simon stevensting tobias trav val virtualboys wolcen wykwit xynosis yksflip
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: coop-cloud/matrix-synapse#23
No description provided.
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?