HomeSolus

Update PostgreSQL to 14.1

Authored by silke on Tue, Nov 16, 7:28 AM.

Description

Update PostgreSQL to 14.1

Summary:
Release notes can be found here and here.

Note that the update instructions need to be updated first, see help-center-docs#303.

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:
python3
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]}")

Reviewers: Triage Team, JoshStrobl

Reviewed By: Triage Team, JoshStrobl

Subscribers: JoshStrobl

Differential Revision: https://dev.getsol.us/D12300

Details

Committed
JoshStroblTue, Nov 16, 7:28 AM
Pushed
JoshStroblTue, Nov 16, 7:28 AM
Reviewer
Triage Team
Differential Revision
D12300: Update PostgreSQL to 14.1
Parents
R2469:db5f57945837: Update PostgreSQL to 13.4
Branches
Unknown
Tags
Unknown
References
HEAD -> master, tag: postgresql-14.1-31