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.
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 |