Defect #17598
open
Wiki page for installation instructions is incomplete
Added by Michel Behr over 10 years ago.
Updated about 10 years ago.
Description
Please correct me if I'm wrong, but AFAIU, what we see here:
http://www.redmine.org/projects/redmine/wiki/redmineinstall#PostgreSQL
Is this:
CREATE ROLE redmine LOGIN ENCRYPTED PASSWORD 'my_password' NOINHERIT VALID UNTIL 'infinity';
CREATE DATABASE redmine WITH ENCODING='UTF8' OWNER=redmine;
When in fact it should THIS:
su postgres
psql
postgres=# CREATE ROLE redmine LOGIN ENCRYPTED PASSWORD '<password>' NOINHERIT VALID UNTIL 'infinity';
postgres=# CREATE DATABASE redmine WITH ENCODING='UTF8' OWNER=redmine TEMPLATE template0;
postgres=# \q
exit
The same applies to MySQL, we should present more complete instructions - shouldn't we...? (I don't have write access to the wiki, that's why I didn't do it on my own).
Please correct me if I'm wrong, but AFAIU, what we see here:
http://www.redmine.org/projects/redmine/wiki/redmineinstall#PostgreSQL
Is this:
CREATE ROLE redmine LOGIN ENCRYPTED PASSWORD 'my_password' NOINHERIT VALID UNTIL 'infinity';
CREATE DATABASE redmine WITH ENCODING='UTF8' OWNER=redmine;
When in fact it should be THIS:
su postgres
psql
postgres=# CREATE ROLE redmine LOGIN ENCRYPTED PASSWORD '<password>' NOINHERIT VALID UNTIL 'infinity';
postgres=# CREATE DATABASE redmine WITH ENCODING='UTF8' OWNER=redmine TEMPLATE template0;
postgres=# \q
exit
The same applies to MySQL, we should present more complete instructions - shouldn't we...? (I don't have write access to the wiki, that's why I didn't do it on my own).
Personally, I don't see the big difference here. Basic knowledge of how to use your system is required anyway, so the wiki might IMHO as well stay as it is, but that's just my 2ct.
Yes, I don't have that basic knowledge... :-) and I understand that at one time one needs to stop explaining and assume SOME basic understanding as a premise - with that in mind my suggestion would be just a link to "psql basics", something like:
http://blog.sensible.io/2013/08/19/postgresql-basics-by-example.html
But yeah, now that I'm having to learn about databases, postgresql, etc, it seems pretty basic really and "standard" before anyone can deal with redmine.
- Category changed from Wiki to Documentation
Also available in: Atom
PDF