Message-ID: <2f061ca5d4c6913b499950bf8f0eda8eb9c615df.camel@scred.nl>
Subject: AWS RDS postgresql upgrade from 14 to 15
From: "alexander al (leiden)" <alexander@scred.nl>
To: pgsql-admin@postgresql.org
Date: Tue, 30 Apr 2024 10:04:21 +0200
Content-Type: text/plain; charset="UTF-8"
User-Agent: Evolution 3.36.5-0ubuntu1 
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Archived-At: 
 <https://www.postgresql.org/message-id/2f061ca5d4c6913b499950bf8f0eda8eb9c615df.camel%40scred.nl>
Precedence: bulk

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.