Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Setup database / grant schema priveleges #61

Open
ZakarFin opened this issue Dec 27, 2024 · 0 comments
Open

Setup database / grant schema priveleges #61

ZakarFin opened this issue Dec 27, 2024 · 0 comments
Milestone

Comments

@ZakarFin
Copy link
Member

ZakarFin commented Dec 27, 2024

Looks like with Postgresql 16 (at least on WSL Ubuntu with defaults on everything) it is also required to do:

grant all privileges on schema public to oskari;

after creating the database and the oskari user. The current docs lists only this:

GRANT ALL PRIVILEGES ON DATABASE oskaridb to oskari;

but looks like it's not enough. Without it the current Flyway version can't make the status-table with an error Message: ERROR: permission denied for schema public. Thought it also notes on log:

Flyway upgrade recommended: PostgreSQL 16.6 is newer than this version of Flyway and support has not been tested. The latest supported version of PostgreSQL is 15.
@ZakarFin ZakarFin added this to the 3.0.0 milestone Jan 28, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant