search

StevenWeathers / thunderdome-planning-poker

⚡ Thunderdome is an open source agile planning poker, sprint retro, and story mapping tool
https://thunderdome.dev
Apache License 2.0
418 stars 109 forks source link

Migrations without supeuser rights #464

Closed Jaz7Mutant closed 1 year ago

Jaz7Mutant commented 1 year ago

I'm trying to self-host this app, but postgres user must have superuser rights to apply migrations. In one migration there is CREATE EXTENSION IF NOT EXISTS "uuid-ossp" expression that requires superuser rights, but there is another migration with DROP EXTENSION "uuid-ossp". Also migrations will fail if there is no "pgcrypto" extension (I had to create it by myself). It would be great (and secure) if superuser rights won't be necessary to apply migrations

StevenWeathers commented 1 year ago

Unfortunately those can't be removed in the current version, however you're in luck as I'm working on version 3 which will be starting with fresh migration scripts that do not include the "uuid-ossp" extension at all.

StevenWeathers commented 1 year ago

v3.0.0 has been released, please give that a try and let me know if you run into any further issues.

Jaz7Mutant commented 1 year ago

Thank you! All migrations were successfully applied without superuser rights