Feature #27985: Support of gem pg 1.0.0 (PostgreSQL) - Redmine

Custom queries

Documentation issues
Open defects
Open features
Patch queue
Plugin issues
Translation patches

Actions

Copy link

Feature #27985

closed

Support of gem pg 1.0.0 (PostgreSQL)

Added by VVD VVD over 6 years ago. Updated about 6 years ago.

Status:

Closed

Priority:

Normal

Assignee:

Category:

Gems support

Target version:

Start date:

Due date:

% Done:

Estimated time:

Resolution:

Description

Redmine 3.4.3 uses gem pg 0.18.1 by default, but work fine with all versions of pg till 0.21.0.
Gem pg 1.0.0 was released January 10, 2018 and Redmine 3.4.3 don't support it.

Related issues

Is duplicate of Redmine - Patch #28505: Update pg gem to 1.0

Closed

Go MAEDA

Actions

Issue # Delay: days Cancel

History
Notes
Property changes

Actions

Copy link

Updated by Go MAEDA over 6 years ago

Category changed from Database to Gems support

I think we can use pg gem v0.21.0 for Redmine 4.0.0 but it is too early to move to pg gem v1.0.0 because it doesn't support PostgreSQL earlier than version 9.2.

Some Linux distributions bundle earlier version of PostgreSQL. For example, CentOS 6.9 bundles PostgreSQL 8.4. Although CentOS 6 is not the latest version, it is widely used in production and CentOS team will support CentOS 6 until November 30, 2020.

pg gem 1.0.0 dropped support for PostgreSQL < 9.2:
https://bitbucket.org/ged/ruby-pg/src/b8d08d4347d564b7ad89c2f3cb26bbdf05dcfe3b/History.rdoc?at=default&fileviewer=file-view-default#History.rdoc-8

CentOS 6 will be supported until November 30, 2020:
https://wiki.centos.org/HowTos/EOL

Actions

Copy link

Updated by Go MAEDA over 6 years ago

Ruby on Rails does not support pg v1.0.0 yet. We have to wait for Rails to support it.

AR 5.1.4 causes `Gem::LoadError` with pg 1.0.0 (wants '~> 0.18') · Issue #31669 · rails/rails

Actions

Copy link

Updated by VVD VVD over 6 years ago

Agree about not to move by default on pg 1.0.0, but if we can add support of pg 1.0.0 - better to do this.

Actions

Copy link

Updated by Go MAEDA over 6 years ago

VVD VVD wrote:

Agree about not to move by default on pg 1.0.0, but if we can add support of pg 1.0.0 - better to do this.

Maybe you will be able to run Redmine with pg v1.0.0 if Ruby on Rails supports it. In other words, you will never be able to use pg v1.0.0 unless Rails supports it. I think there is nothing to do on our side.

Actions

Copy link