Page MenuHomeSolus

Update PostgreSQL to 14.5 and split libpq

Authored by silke on Aug 21 2022, 1:13 PM.



Release notes can be found here.

Resolves T10234

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:
import psycopg2
conn = psycopg2.connect("dbname=pagila")
cur = conn.cursor()
cur.execute("SELECT title, description FROM film WHERE fulltext @@ to_tsquery('saga&india');")
for i in cur.fetchall():
    print(f"Title: {i[0]}, description: {i[1]}")

Diff Detail

R2469 postgresql
Automatic diff as part of commit; lint not applicable.
Automatic diff as part of commit; unit tests not applicable.

Event Timeline

silke created this revision.Aug 21 2022, 1:13 PM
silke requested review of this revision.Aug 21 2022, 1:13 PM
silke added a comment.Aug 21 2022, 1:25 PM

Note that all packages that depend on pkgconfig(libpq) will need a rebuild for the dependency to be updated. However, there is no harm in leaving them be, as postgresql itself depends on postgresql-libpq. AFAIK there are no packages depending on postgresql that should depend on pkgconfig(libpq) instead.

algent requested changes to this revision.Sep 11 2022, 11:19 AM
algent added a subscriber: algent.

While I am verifying rebuilds. Please add the component for postresql-libpq and maybe a summary too, if you find a good one.

This revision now requires changes to proceed.Sep 11 2022, 11:19 AM
silke updated this revision to Diff 33171.Sep 11 2022, 11:41 AM

Add component and summary for libpq

algent accepted this revision.Sep 11 2022, 12:12 PM

LGTM, thanks!

This revision is now accepted and ready to land.Sep 11 2022, 12:12 PM
This revision was automatically updated to reflect the committed changes.

Not that it matters that much, but shouldn't it be ^libpq? Without the postgres- prefix.