Page MenuHomeSolus

Update PostgreSQL to 15.1

Authored by silke on Sat, Nov 19, 10:37 AM.



Release notes:

This update requires manual migration of databases.
Instructions can be found in the Solus Help Center.

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.Sat, Nov 19, 10:37 AM
silke requested review of this revision.Sat, Nov 19, 10:37 AM

PR with updated instructions: help-center-docs#318.

algent requested changes to this revision.Tue, Nov 22, 6:20 PM
algent added a subscriber: algent.

Build fails with this error:
/usr/bin/ld: cannot find -lcrypt: No such file or directory

Please add pkgconfig(libcrypt) to fix it.

This revision now requires changes to proceed.Tue, Nov 22, 6:20 PM
silke updated this revision to Diff 33687.Wed, Nov 23, 11:01 AM

Add build dependency on libcrypt.

algent accepted this revision.Thu, Nov 24, 4:25 PM

LGTM, thanks!

This revision is now accepted and ready to land.Thu, Nov 24, 4:25 PM
This revision was automatically updated to reflect the committed changes.