WindmillWWindmill
Powered by
cdodevC
Windmill•3y ago•
13 replies
cdodev

What permissions does the database user require?

I'm nearly there with my nix/oci-contaner based windmill deployment. But I'm getting:

Nov 22 12:57:12 mc-nix windmill_server[1378228]: Error: Migrating database: while executing migrations: error returned from database: role "windmill_user" does not exist
Nov 22 12:57:12 mc-nix windmill_server[1378228]: 
Nov 22 12:57:12 mc-nix windmill_server[1378228]: Caused by:
Nov 22 12:57:12 mc-nix windmill_server[1378228]:     0: while executing migrations: error returned from database: role "windmill_user" does not exist
Nov 22 12:57:12 mc-nix windmill_server[1378228]:     1: error returned from database: role "windmill_user" does not exist
Nov 22 12:57:12 mc-nix windmill_server[1378228]:     2: role "windmill_user" does not exist
Nov 22 12:57:12 mc-nix windmill_server[1378228]: Error: Migrating database: while executing migrations: error returned from database: role "windmill_user" does not exist
Nov 22 12:57:12 mc-nix windmill_server[1378228]: 
Nov 22 12:57:12 mc-nix windmill_server[1378228]: Caused by:
Nov 22 12:57:12 mc-nix windmill_server[1378228]:     0: while executing migrations: error returned from database: role "windmill_user" does not exist
Nov 22 12:57:12 mc-nix windmill_server[1378228]:     1: error returned from database: role "windmill_user" does not exist
Nov 22 12:57:12 mc-nix windmill_server[1378228]:     2: role "windmill_user" does not exist


I'm connecting with the postgres user to a database running natively on the host machine. Any thoughts on what I might need to tweak?
WindmillJoin
3,362Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements
Recent Announcements
henri-c

Weekly kenote to tell you about our latest updates https://discord.com/channels/930051556043276338/1278977038430240813 https://youtube.com/live/2dGd9TdT8xs?feature=share

henri-c · 4d ago

Pyra

### HTTP tracing (EE) Capture HTTP requests made by job scripts as observability spans Features: - View HTTP request traces (method, URL, status, timing) in the job details UI - Auto-instrumentation for Native TypeScript, MITM proxy for other languages - Integrates with external OpenTelemetry collectors changelog: https://www.windmill.dev/changelog/http-tracing docs: https://www.windmill.dev/docs/advanced/instance_settings#http-tracing Additionally jobs memory metrics are now fully OSS!

Pyra · 2w ago

henri-c

First keynote of the year here https://discord.com/channels/930051556043276338/1278977038430240813 🙂

henri-c · 4w ago

Similar Threads

What is the SQL statements that require Postgres Advisory Lock
kevinightKkevinight / help
9mo ago
Does windmill store user login logs?
brian_gtbBbrian_gtb / help
13mo ago
What is the best way to create a service user?
andnessAandness / help
2y ago
install extra_requirement or requirements without cache?
fooosieeeFfooosieee / help
16mo ago