AWS RDS postgresql upgrade from 14 to 15

Поиск
Список
Период
Сортировка
От alexander al (leiden)
Тема AWS RDS postgresql upgrade from 14 to 15
Дата
Msg-id 2f061ca5d4c6913b499950bf8f0eda8eb9c615df.camel@scred.nl
обсуждение исходный текст
Ответы Re: AWS RDS postgresql upgrade from 14 to 15  (Laurenz Albe <laurenz.albe@cybertec.at>)
Список 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 по дате отправления:

Предыдущее
От: akshay polji
Дата:
Сообщение: HA Setup Review
Следующее
От: Laurenz Albe
Дата:
Сообщение: Re: AWS RDS postgresql upgrade from 14 to 15