Defect #37986

postgresql 15: additional steps required while initializing database

Added by Tomas D 2 months ago. Updated 27 days ago.

Status:NewStart date:
Priority:NormalDue date:
Assignee:-% Done:


Target version:-
Resolution: Affected version:5.0.3


I tried to install on alpine/edge with clean postgresql 15 setup. Errors were produced while initializing database:

prod1:~/redmine$ RAILS_ENV=production bundle exec rake db:migrate
rake aborted!
ActiveRecord::StatementInvalid: PG::InsufficientPrivilege: ERROR:  permission denied for schema public
LINE 1: CREATE TABLE "schema_migrations" ("version" character varyin...

While following installation step 2 (, I had to use additional commands in postgresql:

\c redmine postgres
grant all on schema public to redmine


Only then

RAILS_ENV=production bundle exec rake db:migrate

worked as expected.


#1 Updated by Go MAEDA 27 days ago

  • Category changed from Database to Documentation

Also available in: Atom PDF