Defect #11166: PotgreSQL required version for redMine-2.x.x - Redmine

Actions

Copy link

Defect #11166

closed

PotgreSQL required version for redMine-2.x.x

Added by Nabil Faouzi almost 12 years ago. Updated almost 12 years ago.

Status:

Closed

Priority:

Normal

Assignee:

Category:

Database

Target version:

Start date:

Due date:

% Done:

Estimated time:

Resolution:

Fixed

Affected version:

2.0.1

Description

Hello,

I think they are an error in the installation page for 1.4.x and 2.x.x version of redmine.

The postgreSQL requirement is false, i've migrated since 1.4.3 to 2.0.1 (migrated ruby and rails too with all delegate gems) and the command rake returns:

*(Your version of PostgreSQL (80111) is too old, please upgrade!)*
        from /usr/local/lib/ruby/gems/1.9.1/gems/activerecord-3.2.3/lib/active_record/connection_adapters/postgresql_adapter.rb:334:in `initialize'
        from /usr/local/lib/ruby/gems/1.9.1/gems/activerecord-3.2.3/lib/active_record/connection_adapters/postgresql_adapter.rb:28:in `new'
        from /usr/local/lib/ruby/gems/1.9.1/gems/activerecord-3.2.3/lib/active_record/connection_adapters/postgresql_adapter.rb:28:in `postgresql_connection'

My PostgreSQL Server version is 8.1.11, please change this requirement:

_PostgreSQL 8 or higher

make sure your database datestyle is set to ISO (Postgresql default setting). You can set it using: ALTER DATABASE "redmine_db" SET datestyle="ISO,MDY";
    some bugs in PostgreSQL 8.4.0 and 8.4.1 affect Redmine behavior (#4259, #4314), they are fixed in PostgreSQL 8.4.2
_

Nabil.