Evergreen/PostgreSQL 9.4 support

Bug #1493824 reported by Chris Sharp
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Evergreen
Fix Released
Wishlist
Unassigned

Bug Description

PostgreSQL 9.4 brings a number of desirable features for Evergreen system administrators (release notes: http://www.postgresql.org/docs/9.4/static/release-9-4.html). I'm creating a placeholder bug for incorporating PostgreSQL 9.4 installation (on Debian jessie and Ubuntu 14.04). Working branch to follow.

Tags: pullrequest
Revision history for this message
Chris Sharp (chrissharp123) wrote :

...and I see that Debian jessie is already using PostgreSQL 9.4, so I guess I'm really just doing this for Ubuntu trusty.

Revision history for this message
Chris Sharp (chrissharp123) wrote :
Revision history for this message
Ben Shum (bshum) wrote :

Interesting approach with the Makefile target and automatically adding the PostgreSQL community apt repository. I like it, but haven't fully tested it quite yet.

Marking this bug as "wishlist" since it'll be a new feature and targeting it towards 2.next for future review/inclusion.

Changed in evergreen:
importance: Undecided → Wishlist
status: New → Triaged
milestone: none → 2.next
Revision history for this message
Chris Sharp (chrissharp123) wrote :

I just tested on a fresh 14.04 install and it ran without any warnings. I haven't yet ensured that Evergreen runs on it, however, so that's next.

Revision history for this message
Ben Shum (bshum) wrote :

Taking over this bug and changing it to target PG 9.4 as the baseline version for all distributions that need it (at present, Debian Wheezy and Ubuntu Trusty)

See beginnings of this work in collab branch: collab/dyrcona/wheezy-pg94-testing

http://git.evergreen-ils.org/?p=working/Evergreen.git;a=shortlog;h=refs/heads/collab/dyrcona/wheezy-pg94-testing

Need to add Trusty target changes, and then modify README and other documentation to support the change of minimum/recommended PostgreSQL version.

Changed in evergreen:
milestone: 2.next → 2.12-rc
Revision history for this message
Ben Shum (bshum) wrote :

New changes pushed to working branch: collab/bshum/PG94-testing

http://git.evergreen-ils.org/?p=working/Evergreen.git;a=shortlog;h=refs/heads/collab/bshum/PG94-testing

This includes wording changes for the README to reflect a position where PG 9.4 becomes the default recommended version. Assuming that http://markmail.org/message/bmtha5irlgev5hjc passes the developer vote later.

And also changes to make PG 9.4 the default for Ubuntu Trusty.

Changed in evergreen:
status: Triaged → Confirmed
Revision history for this message
Jason Stephenson (jstephenson) wrote :

I tested everything again on Trusty and Wheezy and stuff works.

I rebased the branch on master, squashed it into 1 commit, rewrote the commit message(s) to be more coherent, and added credit where credit is due. Ben already credited Chris Sharp, but since Ben is now the author of the only commit on the branch, I added a blurb about what I did beyond testing.

The hopefully final branch is at working/collab/dyrcona/lp1493824-PG94-install

http://git.evergreen-ils.org/?p=working/Evergreen.git;a=shortlog;h=refs/heads/collab/dyrcona/lp1493824-PG94-install

I thought we'd wait to hear from the 2.12 RM before pushing this to master.

tags: added: pullrequest
Changed in evergreen:
status: Confirmed → Fix Committed
Changed in evergreen:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.