redmine installation requires user "postgres", which is missing

[François Pinard]

Installing "redmine" 1.0.5 on Ubuntu 11.04 (Natty), using PostgreSQL for a database, fails. The problem is that user "postgres" is referenced by the installation, and this user is missing.

If I install package "postgresql" first, it seems that the user "postgres" gets created. Then "redmine" installation succeeds. The package "redmine-pgsql" depends on "postgresql-client". Maybe it should clearly depend on "postgresql" as well? Currently, "postgresql" is suggested, but this is not strong enough to get the "postgres" user created automatically.

[kapouer (kapouer)]

There are limits to automatic configuration. If you install redmine-pgsql and configure redmine to use postgres,
you are supposed to know what postgres is, and how to make sure you have a running postgres server somewhere.
Since it seems to not be your case, you'd better install
redmine-sqlite and configure it with sqlite database. It is simpler and doesn't require any other installation/configuration.

[François Pinard (fpinard)]

I still think that the problem above is far from reaching the limits of automatic configuration. Ubuntu does a lot of much more complicated things. Currently, the problem would be solved by adding a dependency. That dependency is missing.

It is clear to me that if the package redmine-pgsql is installed, both Redmine and PostgreSQL are needed, and dependencies could very well represent this. I just do not understand your objection.

If I am asked to install Redmine with PostgreSQL under Ubuntu, I do not have to know what Redmine is nor to make sur I have a running PostgreSQL server. Merely installing PostgreSQL has it running automatically already. Ubuntu does this correctly.

I'm not "better install redmine-sqlite", if this is not what I am asked to do. Please do not infer my needs, but rather read the problem I am reporting.

Thanks.