Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sgqmi-009343-MP for pgsql-general@arkaria.postgresql.org; Wed, 21 Aug 2024 19:14:21 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sgqme-00EI6J-KZ for pgsql-general@arkaria.postgresql.org; Wed, 21 Aug 2024 19:14:17 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sgqmd-00EI4b-O3 for pgsql-general@lists.postgresql.org; Wed, 21 Aug 2024 19:14:16 +0000 Received: from mail-qt1-x82d.google.com ([2607:f8b0:4864:20::82d]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sgqmb-000mBw-8H for pgsql-general@lists.postgresql.org; Wed, 21 Aug 2024 19:14:14 +0000 Received: by mail-qt1-x82d.google.com with SMTP id d75a77b69052e-44fdcd7a622so570491cf.0 for ; Wed, 21 Aug 2024 12:14:13 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1724267651; x=1724872451; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=EPBCpALgz2/EWElnX/IhbOpfgIle3kbVAfAQ4KQ/9JA=; b=VDonACnPFNaR2Z0A0lPChUM2jmp9TYai47hMj1H8ksw8VyipEbmp7knAWEOpCsaaa/ Q0myoNixHxQqx1dtLEza2xeq9x4fbzvwYqp8tCsqsHuaSgPUcqDiAcvtWLRxKJ24am+p SSydabyVOy2uqc8lPEwvbaXzkR7LD3dD1hQbzlmpmaLXGcIROWlhhg9vBpQd1bOwpNR2 RQh6ah8t7ORiPqItPVkVbPxxL0rvr9nFP/pOATaE5FU20wj0SMTZiTF8sf+s2qSxHZPa /8yTuVAnFFjC3TlROgEAiKPbRp+3hJ9+HzOY2N46LrCkAef2Vyt0KnkxA3weyuTsjNcY Lj9Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1724267651; x=1724872451; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=EPBCpALgz2/EWElnX/IhbOpfgIle3kbVAfAQ4KQ/9JA=; b=Y24BSoto1D4LsB+JqEjCXuL2suPujqkY0BrlVie8zsMWkGC+Uu6iUjENqTsX0cBM4O +E65dqWCWsB+QJinFVXPNz7rN6Bv7b1QOUFqBNgCZ5D9CFkVyzknQ02KQe3xa2jL8F18 OooctrWZu5U+Lrjzsi416MM9I9b33a4/jekVXHPN0h4dVrDM9f3VRMGADhOTWmZlWns7 3zQfKOV3fl6XCVK1o6fOA4yF3Mm3sdsvoAyjDBHzUvOlXrqjmAdGCtB6hWUdGSIQjTf2 qnUuvDZtE5OFQiRXYnF+w8Rm/BcVypMSn/7bLveJRRjMkphiCpuryd7g11KtNoVtg2Df ZWWw== X-Gm-Message-State: AOJu0Yz8w2FTKKC4WV7NYWLiUDohOIm1xHeUvnbzjT3Ows/LX/wc+yD/ 0KZqfco6f9gnxtmIDC/srHhrk08sh59VO83C39j3xZCnofdNZoAk7viyNkEP0lB47AkotY4ocIv Wg0mX7zW7J1s6rE7AfmohFNVlzVevD++s X-Google-Smtp-Source: AGHT+IEqvJ0ueIOJXLBVJrKhhulMtAC2Olgp4CBUfbIy9PGP6O7v+DVE75CZYSuPGrNtiMdgYY6DDBwXgUVVdzYZ82I= X-Received: by 2002:a05:622a:59c4:b0:43f:edde:7a55 with SMTP id d75a77b69052e-454f2227462mr38837981cf.28.1724267651172; Wed, 21 Aug 2024 12:14:11 -0700 (PDT) MIME-Version: 1.0 From: plsqlvids01 plsqlvids01 Date: Wed, 21 Aug 2024 15:14:00 -0400 Message-ID: Subject: unable to upgrade postgres extensions To: pgsql-general@lists.postgresql.org Content-Type: multipart/alternative; boundary="000000000000d896270620365801" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000d896270620365801 Content-Type: text/plain; charset="UTF-8" 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" --000000000000d896270620365801 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable

AWS RDS Postgr= es database on v12.17 is upgraded to v16.1, as per=C2=A0https://docs.aws.amazon.= com/AmazonRDS/latest/PostgreSQLReleaseNotes/postgresql-extensions.html#post= gresql-extensions-16x=C2=A0am trying to upgrade pg_cron and pgaudit ext= ensions but it keeps throwing the same error, how to upgrade them?

postgres=3D=
> 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-b=
it
(1 r=
ow)

postgres=3D> select * from pg_extension;
  oid  | extname | extowner | extnamespace | extrelocatab=
le | extversion |         extconfig         | extcondition
-------+---------+----------+------------=
--+----------------+------------+---------------------------+--------------=
-
 14501 | plpgsql |       <=
span class=3D"gmail-hljs-number" style=3D"margin:0px;padding:0px;border:0px=
;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:i=
nherit;line-height:inherit;font-family:inherit;font-size-adjust:inherit;fon=
t-kerning:inherit;font-feature-settings:inherit;font-size:13px;vertical-ali=
gn:baseline;box-sizing:inherit">10 11 | f              | 1.0        |                           |
 16410 | pg_cron |       <=
span class=3D"gmail-hljs-number" style=3D"margin:0px;padding:0px;border:0px=
;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:i=
nherit;line-height:inherit;font-family:inherit;font-size-adjust:inherit;fon=
t-kerning:inherit;font-feature-settings:inherit;font-size:13px;vertical-ali=
gn:baseline;box-sizing:inherit">10 11 | f              | 1.6        | {1642=
5,16423,16447,16445} | {"","","=
",""}
 16413 | pgaudit |       <=
span class=3D"gmail-hljs-number" style=3D"margin:0px;padding:0px;border:0px=
;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:i=
nherit;line-height:inherit;font-family:inherit;font-size-adjust:inherit;fon=
t-kerning:inherit;font-feature-settings:inherit;font-size:13px;vertical-ali=
gn:baseline;box-sizing:inherit">10 16412 | t              | 1.4.3      |                           |
(3 =3D> select * from pg_available_extensions wher=
e name in  ('pgaudit','pg_cron');
  name   | default_version | installed_version |             comment
---------+-----------------+-------------=
------+---------------------------------
 pgaudit | 16.0            | 1.4.3             | provi=
des auditing functionality
 pg_cron | 1.6             | 1.6               | Job scheduler for PostgreSQL
(2 =3D> ALTER EXT=
ENSION pgaudit update to "16.0";
ERROR:  extension "pgaudit" has no update path from version "1.4.3" to version "16.0"
postgres=3D> ALTER EXT=
ENSION pgaudit update to "16.0.0";
ERROR:  extension "pgaudit" has no update path from version "1.4.3" to version "16.0.0"
postgres=3D> ALTER EXT=
ENSION pgaudit update to "16.0.1";
ERROR:  extension "pgaudit" has no update path from version "1.4.3" to version "16.0.1"

postgres=3D> ALTER EXT=
ENSION pg_cron update to "1.6.1";
ERROR:  extension "pg_cron" has no update path from version "1.6" to version "1.6.1"
--000000000000d896270620365801--