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.

8 Replies

Codercord•2mo ago

<#1304921430332538890>

Category

Feature request

Product

Coder OSS (v2)

Platform

Windows

Logs

Please post any relevant logs/error messages.

Phorcys•2mo ago

@nVitius I think you're okay to just ignore that

nVitiusOP•2mo 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•2mo 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•2mo ago

https://github.com/coder/coder/issues

GitHub

Issues · coder/coder

Provision remote development environments via Terraform - Issues · coder/coder

Atif•2mo 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•2mo ago

I don’t think they’re related I do think this is just a windows specific Postgres encoding error

Codercord•2w ago

@Théo closed the thread.

Gaming

Programming

Coder on Windows

Did you find this page helpful?