https://www.redmine.org/https://www.redmine.org/favicon.ico?16793021292018-04-08T12:01:08ZRedmineRedmine - Patch #28505: Update pg gem to 1.0https://www.redmine.org/issues/28505?journal_id=844342018-04-08T12:01:08ZMarius BÄ‚LTEANU
<ul><li><strong>Copied from</strong> <i><a class="issue tracker-3 status-5 priority-4 priority-default closed" href="/issues/28504">Patch #28504</a>: Update mysql2 gem to 0.5.0</i> added</li></ul> Redmine - Patch #28505: Update pg gem to 1.0https://www.redmine.org/issues/28505?journal_id=844362018-04-08T12:05:53ZGo MAEDA
<ul><li><strong>Has duplicate</strong> <i><a class="issue tracker-2 status-5 priority-4 priority-default closed" href="/issues/27985">Feature #27985</a>: Support of gem pg 1.0.0 (PostgreSQL)</i> added</li></ul> Redmine - Patch #28505: Update pg gem to 1.0https://www.redmine.org/issues/28505?journal_id=845082018-04-11T23:49:44ZMizuki ISHIKAWA
<ul></ul><ul>
<li>pg 1.0.0</li>
<li>postgresql 9.5.3</li>
</ul>
<p>I confirmed that all the tests are green under the above conditions.</p>
<pre>
<code class="diff syntaxhl"><span class="gh">diff --git a/Gemfile b/Gemfile
index a3f99a1ec..94dc31301 100644
</span><span class="gd">--- a/Gemfile
</span><span class="gi">+++ b/Gemfile
</span><span class="p">@@ -62,7 +62,7 @@</span> if File.exist?(database_file)
when 'mysql2'
gem "mysql2", "~> 0.4.6", :platforms => [:mri, :mingw, :x64_mingw]
when /postgresql/
<span class="gd">- gem "pg", "~> 0.18.1", :platforms => [:mri, :mingw, :x64_mingw]
</span><span class="gi">+ gem "pg", "~> 1.0.0", :platforms => [:mri, :mingw, :x64_mingw]
</span> when /sqlite3/
gem "sqlite3", "~>1.3.12", :platforms => [:mri, :mingw, :x64_mingw]
when /sqlserver/
</code><br /></pre> Redmine - Patch #28505: Update pg gem to 1.0https://www.redmine.org/issues/28505?journal_id=845102018-04-12T00:15:38ZGo MAEDA
<ul><li><strong>Target version</strong> set to <i>4.0.0</i></li></ul><p>Mizuki ISHIKAWA wrote:</p>
<blockquote>
<ul>
<li>pg 1.0.0</li>
<li>postgresql 9.5.3</li>
</ul>
<p>I confirmed that all the tests are green under the above conditions.</p>
</blockquote>
<p>Thanks, setting target version to 4.0.0.</p> Redmine - Patch #28505: Update pg gem to 1.0https://www.redmine.org/issues/28505?journal_id=845132018-04-12T03:24:02ZGo MAEDA
<ul></ul><p>pg 1.0.0 supports PostgreSQL 9.2 and later. If we update pg gem to 1.0.0, Redmine cannot run on some operating systems such as CentOS 6 (PostgreSQL is 8.4).</p>
<p>It may be too early to update to pg 1.0.0.</p> Redmine - Patch #28505: Update pg gem to 1.0https://www.redmine.org/issues/28505?journal_id=850402018-05-16T04:25:05ZShinichi Yanagisawa
<ul></ul><blockquote>
<p>pg 1.0.0 supports PostgreSQL 9.2 and later. If we update pg gem to 1.0.0, Redmine cannot run on some operating systems such as CentOS 6 (PostgreSQL is 8.4).</p>
<p>It may be too early to update to pg 1.0.0.</p>
</blockquote>
<p>PostgreSQL 8.4 is not a supported version in the PG community, so to update pg 1.0.0 is NOT too early in terms of security.<br /><a class="external" href="https://www.postgresql.org/support/versioning/">https://www.postgresql.org/support/versioning/</a></p>
<p>Anyway, CentOS 6 and 7 does not support Ruby 2.2 or higher as standard, but Redmine 4.0 will require Ruby 2.2 or higher. It means in any case Redmine 4.0 does not work on CentOS with only standard repository. I think you should consider the OS version that supports Ruby 2.2 or higher as a criteria and present PostrgreSQL's workaround same as Ruby installation if they use an OS like CentOS.</p> Redmine - Patch #28505: Update pg gem to 1.0https://www.redmine.org/issues/28505?journal_id=850422018-05-16T08:21:41ZGo MAEDA
<ul></ul><p>"Maintenance Support 1 Phase" for RHEL 6 and "Full Updates phase" for CentOS 6 ended on May 10, 2017. RHEL / CentOS 6 users should prioritize to update the operating system rather than Redmine.</p>
<p><a class="external" href="https://access.redhat.com/support/policy/updates/errata#Life_Cycle_Dates">https://access.redhat.com/support/policy/updates/errata#Life_Cycle_Dates</a><br /><a class="external" href="https://wiki.centos.org/About/Product">https://wiki.centos.org/About/Product</a></p> Redmine - Patch #28505: Update pg gem to 1.0https://www.redmine.org/issues/28505?journal_id=853452018-06-02T07:28:39ZGo MAEDA
<ul><li><strong>Status</strong> changed from <i>New</i> to <i>Closed</i></li><li><strong>Assignee</strong> set to <i>Go MAEDA</i></li></ul><p>Committed. Thank you all for the contribution.</p>