Page MenuHomeSolus

Update PostgreSQL to 13.1 and build against Python3
Needs ReviewPublic

Authored by silke on Jan 27 2021, 1:03 PM.


Group Reviewers
Triage Team

Release notes:

Note: users of local databases will need to perform a manual migation.

Test Plan
psql postgres -c "CREATE DATABASE pagila;"
psql pagila < pagila-schema.sql
psql pagila < pagila-data.sql
psql pagila -c "SELECT title, description FROM film WHERE fulltext @@ to_tsquery('saga&india');"
  • Connect to database using LibreOffice Base.
  • Connect to database using Psycopg2.

Diff Detail

R2469 postgresql
No Linters Available
No Unit Test Coverage

Event Timeline

silke created this revision.Jan 27 2021, 1:03 PM
silke requested review of this revision.Jan 27 2021, 1:03 PM
silke edited the test plan for this revision. (Show Details)Jan 27 2021, 1:04 PM
silke edited the test plan for this revision. (Show Details)
silke added a comment.Jan 27 2021, 1:16 PM

The manual upgrade process mentioned is different compared to other distros because we don't have different packages for different Postgres versions.
Shall I write some instructions for the Help Center?

algent added a subscriber: algent.Jan 27 2021, 9:43 PM

I suggest two minor things in the package.yml file: replace python3-devel with pkgconfig(python3) and move patterns: before builddeps:. If you want to add the homepage: too, then it is this:

silke updated this revision to Diff 25173.Jan 28 2021, 12:10 PM

Incorporate suggestions from @algent:

  • Change python3-devel to pkgconfig(python3)
  • Move patterns above builddeps
  • Add homepage
JoshStrobl requested changes to this revision.Feb 5 2021, 7:12 AM
JoshStrobl added a subscriber: JoshStrobl.

LGTM. In terms of a migration guide, it would be ideal if one could be submitted, but we would still need to give folks an adequate heads up, likely via a section in a "The Roundup" blog post. So I'm gonna hold off landing this until that point (and until a help center doc is submitted).

This revision now requires changes to proceed.Feb 5 2021, 7:12 AM
silke updated this revision to Diff 25399.Feb 13 2021, 1:46 PM

Update to PostgreSQL 13.2

PR with upgrade instructions: