From: alexander al (leiden) <alexander@scred.nl>
To: pgsql-admin@postgresql.org
Subject: AWS RDS postgresql upgrade from 14 to 15
Date: Tue, 30 Apr 2024 10:04:21 +0200
Message-ID: <2f061ca5d4c6913b499950bf8f0eda8eb9c615df.camel@scred.nl> (raw)
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: alexander@scred.nl
Subject: Re: AWS RDS postgresql upgrade from 14 to 15
In-Reply-To: <2f061ca5d4c6913b499950bf8f0eda8eb9c615df.camel@scred.nl>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox