fix: explicitly set encoding to UTF8 on embedded postgres (#16604)

hugodutka · web-flow · commit 5e96fb598557 · 2025-02-18T15:29:10.000+01:00
Fixes #16228. I've verified that the setting does not affect existing databases.
diff --git a/cli/server.go b/cli/server.go
@@ -2022,6 +2022,7 @@ func startBuiltinPostgres(ctx context.Context, cfg config.Root, logger slog.Logg
 			Username("coder").
 			Password(pgPassword).
 			Database("coder").
+			Encoding("UTF8").
 			Port(uint32(pgPort)).
 			Logger(stdlibLogger.Writer()),
 	)

Original file line number	Diff line number	Diff line change
`@@ -2022,6 +2022,7 @@ func startBuiltinPostgres(ctx context.Context, cfg config.Root, logger slog.Logg`
`2022`	`2022`	`Username("coder").`
`2023`	`2023`	`Password(pgPassword).`
`2024`	`2024`	`Database("coder").`
	`2025`	`+ Encoding("UTF8").`
`2025`	`2026`	`Port(uint32(pgPort)).`
`2026`	`2027`	`Logger(stdlibLogger.Writer()),`
`2027`	`2028`	`)`