Redmine

But in my opinion:

At the installation a role and a database owned by that role is
created.

The migrate scripts should take on that role. Read the config/database.yml or something.

Or at least there should be some instruction on how to take that role from the command line.

RAILS_ENV=production bundle exec rake db:migrate

// GH

Maybe the commands in the installation manual is outdated

Example:

psql -U postgres -h localhost
psql (15.1)

postgres=# CREATE ROLE test3 LOGIN ENCRYPTED PASSWORD 'test123' NOINHERIT VALID UNTIL 'infinity';
CREATE ROLE

postgres=# create database test3 with encoding='UTF8' OWNER=test3;
CREATE DATABASE
postgres=# \q

gorhas@www:~ $ psql -U test3 -h localhost test3
psql (15.1)

test3=> create table demo( name varchar default '' );
ERROR:  permission denied for schema public
LINE 1: create table demo( name varchar default '' );
                     ^
test3=> 

If I do like this... it works

psql -U postgres -h localhost
psql (15.1)

postgres=# create user test4 with encrypted password 'test123';
CREATE ROLE

postgres=# create database test4 template default owner test4;
CREATE DATABASE

postgres=# \q

gorhas@www:~ $ psql -W -U test4 -h localhost test4
Password: 
psql (15.1)

test4=> create table demo( name varchar default '' );
CREATE TABLE
test4=>