public inbox for [email protected]
help / color / mirror / Atom feedFrom: plsqlvids01 plsqlvids01 <[email protected]>
To: [email protected]
Subject: unable to upgrade postgres extensions
Date: Wed, 21 Aug 2024 15:14:00 -0400
Message-ID: <CAFsfSru+ZfPVF8xQiPf2Ug4YBS6fSzBC+TCos_3ey7EamnFpsg@mail.gmail.com> (raw)
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#postg...
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"
view thread (4+ messages) latest in thread
reply
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: [email protected]
Cc: [email protected], [email protected]
Subject: Re: unable to upgrade postgres extensions
In-Reply-To: <CAFsfSru+ZfPVF8xQiPf2Ug4YBS6fSzBC+TCos_3ey7EamnFpsg@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox