AWS RDS postgresql upgrade from 14 to 15 - Mailing list pgsql-admin

From alexander al (leiden)
Subject AWS RDS postgresql upgrade from 14 to 15
Date
Msg-id 2f061ca5d4c6913b499950bf8f0eda8eb9c615df.camel@scred.nl
Whole thread Raw
Responses Re: AWS RDS postgresql upgrade from 14 to 15  (Laurenz Albe <laurenz.albe@cybertec.at>)
List 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.




pgsql-admin by date:

Previous
From: akshay polji
Date:
Subject: HA Setup Review
Next
From: Laurenz Albe
Date:
Subject: Re: AWS RDS postgresql upgrade from 14 to 15