[FOLIO-883] Postgresql v10 is now the current released postgres Created: 05/Oct/17  Updated: 19/Aug/19  Resolved: 28/Jan/19

Status: Closed
Project: FOLIO
Components: Continuous Integration
Affects versions: None
Fix versions: None

Type: New Feature Priority: P3
Reporter: Wayne Schneider Assignee: Unassigned
Resolution: Duplicate Votes: 0
Labels: back-end, ci, core, devops, platform-backlog, sprint54
Remaining Estimate: Not Specified
Time Spent: 30 minutes
Original estimate: Not Specified

Issue links:
Duplicate
duplicates FOLIO-1438 Upgrade to PostgreSQL 10 Closed
Sprint:
Development Team: Core: Platform

 Description   

All our build scripts rely on v9.6. I suppose we need to test v10, as well. At the moment, we can't build a backend system.



 Comments   
Comment by Wayne Schneider [ 05/Oct/17 ]

shale99 – any thoughts on whether we should look at moving to v10?

Comment by Wayne Schneider [ 05/Oct/17 ]

For now, I have pinned the postgresql role in folio-ansible to v9.6.

Comment by shale99 [ 08/Oct/17 ]

at this stage of the project - i am for upgrading whenever the embedded postgres we use for testing allows for it. right now the latest version supported by the embedded postgres is 9.6.2 - once v10 is supported (assuming its a reasonable time before the major release) i think we should upgrade

Comment by Wayne Schneider [ 09/Oct/17 ]

Thanks, shale99 – I will close this issue for now. Can you let us know when v10 is supported by the embedded postgres package and we can reopen it?

Comment by Julian Ladisch [ 27/Aug/18 ]

Wayne Schneider: We need ICU sorting collation ( FOLIO-1438 Closed , CQLPG-26 Blocked ).
The minimal postgresql version supporting ICU sorting collation is 10.0 ("Allow the ICU library to optionally be used for collation support" https://www.postgresql.org/docs/current/static/release-10.html ).
RMB and embedded-postgresql use version 10 since February 2018 ( RMB-128 Closed ) in the tests (unit tests, integration tests).
Please change https://github.com/folio-org/folio-ansible/blob/master/roles/postgresql/tasks/main.yml so that 9.6 is no longer pinned and the ansible/vagrant box uses postgresql version >=10.

Comment by Julian Ladisch [ 02/Oct/18 ]

There were no objections against using PostgreSQL 10 at today's core backend meeting. See also FOLIO-1438 Closed .

Comment by Jakub Skoczen [ 17/Oct/18 ]

John MalconianWayne Schneider I am unassigning this but putting in the sprint so if we run out of tasks we can address it.

Comment by Jakub Skoczen [ 26/Nov/18 ]

John Malconian Wayne Schneider Guys, let's make a decision this week if this is somethign we want to do before the Q4 release.

Comment by Jakub Skoczen [ 22/Jan/19 ]

Wayne Schneider is this a duplicate of FOLIO-1438 Closed

Comment by Wayne Schneider [ 22/Jan/19 ]

Jakub Skoczen Yes, I believe it is.

Generated at Thu Feb 08 23:09:01 UTC 2024 using Jira 1001.0.0-SNAPSHOT#100246-sha1:7a5c50119eb0633d306e14180817ddef5e80c75d.