| 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: | Whole Thread | Raw Message | 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 |