AWS RDS postgresql upgrade from 14 to 15

From: "alexander al (leiden)" <alexander(at)scred(dot)nl>
To: pgsql-admin(at)postgresql(dot)org
Subject: AWS RDS postgresql upgrade from 14 to 15
Date: 2024-04-30 08:04:21
Message-ID: 2f061ca5d4c6913b499950bf8f0eda8eb9c615df.camel@scred.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

Because gitlab next major upgrade needs a newer version of postgresql
we have to upgrade it.

What we have:

postgres=> select version();
version

---------------------------------------------------------------------
-----------------------------------------
PostgreSQL 14.6 on aarch64-unknown-linux-gnu, compiled by gcc (GCC)
7.3.1 20180712 (Red Hat 7.3.1-6), 64-bit
(1 row)

and

List of installed extensions
Name | Version
| Schema | Description

------------+---------+------------+-----------------------------------
--------------------------------
btree_gist | 1.6 | public | support for indexing common
datatypes in GiST
pg_trgm | 1.6 | public | text similarity measurement and
index searching based on trigrams
plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language
(3 rows)

now normally I would probably do 'upgrade' in the aws-console but on
aws rds PG 15 has a newer btree_gist version (1.7)

Are there any caveats concerning those extensions?

best regards,

Alexander.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Laurenz Albe 2024-04-30 08:50:44 Re: AWS RDS postgresql upgrade from 14 to 15
Previous Message akshay polji 2024-04-30 07:40:56 HA Setup Review