Project

General

Profile

Actions

Feature #27985

closed

Support of gem pg 1.0.0 (PostgreSQL)

Added by VVD VVD almost 7 years ago. Updated over 6 years ago.

Status:
Closed
Priority:
Normal
Assignee:
-
Category:
Gems support
Target version:
-
Start date:
Due date:
% Done:

0%

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.0ClosedGo MAEDA

Actions
Actions #1

Updated by Go MAEDA almost 7 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 #2

Updated by Go MAEDA almost 7 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 #3

Updated by VVD VVD almost 7 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 #4

Updated by Go MAEDA almost 7 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 #5

Updated by VVD VVD almost 7 years ago

Ok. Close? Or Waiting unless Rails supports it?

Actions #6

Updated by Go MAEDA almost 7 years ago

VVD VVD wrote:

Ok. Close? Or Waiting unless Rails supports it?

I would like to keep this issue open until we have updated to the latest version of pg gem.

Actions #7

Updated by Go MAEDA over 6 years ago

Actions #8

Updated by Go MAEDA over 6 years ago

  • Status changed from New to Closed
Actions #9

Updated by Marius BĂLTEANU over 6 years ago

Go Maeda, sorry for not finding this ticket.

Actions

Also available in: Atom PDF