unable to upgrade postgres extensions - Mailing list pgsql-general

From plsqlvids01 plsqlvids01
Subject unable to upgrade postgres extensions
Date
Msg-id CAFsfSru+ZfPVF8xQiPf2Ug4YBS6fSzBC+TCos_3ey7EamnFpsg@mail.gmail.com
Whole thread Raw
Responses Re: unable to upgrade postgres extensions
Re: unable to upgrade postgres extensions
Re: unable to upgrade postgres extensions
List pgsql-general

AWS RDS Postgres database on v12.17 is upgraded to v16.1, as per https://docs.aws.amazon.com/AmazonRDS/latest/PostgreSQLReleaseNotes/postgresql-extensions.html#postgresql-extensions-16x am trying to upgrade pg_cron and pgaudit extensions but it keeps throwing the same error, how to upgrade them?

postgres=> select version();                                                 version
--------------------------------------------------------------------------------------------------------- PostgreSQL 16.1 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 7.3.1 20180712 (Red Hat 7.3.1-12), 64-bit
(1 row)

postgres=> select * from pg_extension;  oid  | extname | extowner | extnamespace | extrelocatable | extversion |         extconfig         | extcondition
-------+---------+----------+--------------+----------------+------------+---------------------------+--------------- 14501 | plpgsql |       10 |           11 | f              | 1.0        |                           | 16410 | pg_cron |       10 |           11 | f              | 1.6        | {16425,16423,16447,16445} | {"","","",""} 16413 | pgaudit |       10 |        16412 | t              | 1.4.3      |                           |
(3 rows)
postgres=> select * from pg_available_extensions where name in  ('pgaudit','pg_cron');  name   | default_version | installed_version |             comment
---------+-----------------+-------------------+--------------------------------- pgaudit | 16.0            | 1.4.3             | provides auditing functionality pg_cron | 1.6             | 1.6               | Job scheduler for PostgreSQL
(2 rows)

postgres=> ALTER EXTENSION pgaudit update to "16.0";
ERROR:  extension "pgaudit" has no update path from version "1.4.3" to version "16.0"
postgres=> ALTER EXTENSION pgaudit update to "16.0.0";
ERROR:  extension "pgaudit" has no update path from version "1.4.3" to version "16.0.0"
postgres=> ALTER EXTENSION pgaudit update to "16.0.1";
ERROR:  extension "pgaudit" has no update path from version "1.4.3" to version "16.0.1"

postgres=> ALTER EXTENSION pg_cron update to "1.6.1";
ERROR:  extension "pg_cron" has no update path from version "1.6" to version "1.6.1"

pgsql-general by date:

Previous
From: Daniel Gustafsson
Date:
Subject: Re: Npgsql.dll
Next
From: Adrian Klaver
Date:
Subject: Re: unable to upgrade postgres extensions