From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | plsqlvids01 plsqlvids01 <plsqlvids01(at)gmail(dot)com> |
Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: unable to upgrade postgres extensions |
Date: | 2024-08-21 22:36:40 |
Message-ID: | 1896127.1724279800@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
plsqlvids01 plsqlvids01 <plsqlvids01(at)gmail(dot)com> writes:
> 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?
You seem to be assuming that PG extensions have versioning matching
the core server. There's no requirement for that, and it doesn't
look like these extensions attempt to keep those numbers in sync.
The underlying compiled modules (.so files) do need to be updated
for each major server version. But if they load and work then
that's happened. The "extension version" is just an arbitrary
identifier for the version of the extension's SQL-level declarations,
which frequently don't need to change for a server update.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | jian he | 2024-08-22 05:19:00 | Re: Emitting JSON to file using COPY TO |
Previous Message | Alvaro Herrera | 2024-08-21 22:09:26 | Re: unable to upgrade postgres extensions |