Coder on Windows

Running coder server on Windows results in Postgres errors:
2024-11-09 20:58:52.203 [erro] coderd.dbrollup: failed to rollup data ...
error= execute transaction:
github.com/coder/coder/v2/coderd/database.(*sqlQuerier).runTx
/home/runner/work/coder/coder/coderd/database/db.go:214
- pq: character with byte sequence 0xce 0xbc in encoding "UTF8" has no equivalent in encoding "WIN1252"
failed to sync sloghuman: sync /dev/stderr: The handle is invalid.
2024-11-09 20:58:52.203 [erro] coderd.dbrollup: failed to rollup data ...
error= execute transaction:
github.com/coder/coder/v2/coderd/database.(*sqlQuerier).runTx
/home/runner/work/coder/coder/coderd/database/db.go:214
- pq: character with byte sequence 0xce 0xbc in encoding "UTF8" has no equivalent in encoding "WIN1252"
failed to sync sloghuman: sync /dev/stderr: The handle is invalid.
Researching it online, it looks like the postgres db encoding is set incorrectly. Not sure how to connect to the instance in order to change it.
7 Replies
Codercord
Codercord2mo ago
<#1304921430332538890>
Category
Feature request
Product
Coder OSS (v2)
Platform
Windows
Logs
Please post any relevant logs/error messages.
Phorcys
Phorcys2mo ago
@nVitius I think you're okay to just ignore that
nVitius
nVitiusOP2mo ago
thanks for confirming. seems like a really easy fix though, even if it is just to clean up the logs. Can I connect to the postgres instance to change the encoding?
Phorcys
Phorcys2mo ago
should be localhost:43779 @nVitius in general if you're planning to run Coder in prod you should switch to a full-blown postgres database rather than the built-in one could you raise an issue over on our github? if your fix works all we should need to do is set the default encoding on windows
Phorcys
Phorcys2mo ago
GitHub
Issues · coder/coder
Provision remote development environments via Terraform - Issues · coder/coder
Atif
Atif2mo ago
@zounce I think its related to https://github.com/coder/coder/issues/15311 And we have already fixed that in main should be fixed in 2.18.0
GitHub
500 Error on Duplicate Template Name Change, No UI Error Displayed ...
When selecting a template from the template list, opening "Settings," and attempting to change the name to one that already exists, the API returns a 500 error with the following message....
zounce
zounce2mo ago
I don’t think they’re related I do think this is just a windows specific Postgres encoding error
Want results from more Discord servers?
Add your server