pixeleet
pixeleet6mo ago

Stuck in migration hell during upgrade.

{"timestamp":"2024-05-10T12:38:45.990624Z","level":"INFO","message":"Acquired global PG lock","target":"windmill_api::db"}
{"timestamp":"2024-05-10T12:38:45.996531Z","level":"INFO","message":"Started applying migration 20240415144144: tighten delete permissions","target":"windmill_api::db"}
{"timestamp":"2024-05-10T12:38:46.003459Z","level":"INFO","message":"Finished applying migration 20240415144144","target":"windmill_api::db"}
Error: Migrating database: while executing migrations: error returned from database: must be owner of relation resource
{"timestamp":"2024-05-10T12:38:45.990624Z","level":"INFO","message":"Acquired global PG lock","target":"windmill_api::db"}
{"timestamp":"2024-05-10T12:38:45.996531Z","level":"INFO","message":"Started applying migration 20240415144144: tighten delete permissions","target":"windmill_api::db"}
{"timestamp":"2024-05-10T12:38:46.003459Z","level":"INFO","message":"Finished applying migration 20240415144144","target":"windmill_api::db"}
Error: Migrating database: while executing migrations: error returned from database: must be owner of relation resource
5 Replies
pixeleet
pixeleet6mo ago
GitHub
windmill/backend/migrations/20240415144144_tighten_delete_permissio...
Open-source developer platform to turn scripts into workflows and UIs. Fastest workflow engine (5x vs Airflow). Open-source alternative to Airplane and Retool. - windmill-labs/windmill
pixeleet
pixeleet6mo ago
How can I get around this one?
rubenf
rubenf6mo ago
Stack Overflow
Postgresql: error "must be owner of relation" when changing a owner...
What is the grant option/trick I need to give to the current user ("userA") to allow him to change a object's owner which belongs by another user ("userC")? More precisely, the
rubenf
rubenf6mo ago
you have to check who is the current owner of those tables and make sure the user you use for the servers is the owner
pixeleet
pixeleet6mo ago
thank you. that worked.