HomeSolus

Update PostgreSQL to 13.4

Authored by silke on Aug 20 2021, 11:17 AM.

Description

Update PostgreSQL to 13.4

Summary:
Fixes CVE-2021-3677 and various other bugs.
Release notes can be found here.

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/D11677

Details

Committed
JoshStroblAug 20 2021, 11:17 AM
Pushed
JoshStroblAug 20 2021, 11:17 AM
Reviewer
Triage Team
Differential Revision
D11677: Update PostgreSQL to 13.4
Parents
R2469:aecdc939cfcb: Rebuild against python 3.9
Branches
Unknown
Tags
Unknown
References
tag: postgresql-13.4-30