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 1sQuUE-00CI2J-AE for pgsql-general@arkaria.postgresql.org; Mon, 08 Jul 2024 19:57:22 +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 1sQuUC-008VgH-B1 for pgsql-general@arkaria.postgresql.org; Mon, 08 Jul 2024 19:57:20 +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 1sQuUB-008Vg8-Pc for pgsql-general@lists.postgresql.org; Mon, 08 Jul 2024 19:57:19 +0000 Received: from mail-ot1-x32f.google.com ([2607:f8b0:4864:20::32f]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sQuU8-0015Dm-Or for pgsql-general@postgresql.org; Mon, 08 Jul 2024 19:57:18 +0000 Received: by mail-ot1-x32f.google.com with SMTP id 46e09a7af769-70367667576so742152a34.1 for ; Mon, 08 Jul 2024 12:57:16 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1720468636; x=1721073436; darn=postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=CJnqQ8efHAnIR9B9EaA5p6X3tWdR/onOQ+bUH8a9TWA=; b=K3+3bP/57qttuPUgbrFNYLAbuChYfGQvuZfMDVA8ST0D2AxwN5AZs/6LnkiElL8ekX GgJUj2mpQqslF3+ggCsdQe2JV1uLf3gNcimvtIUQwJoGV1TcXanN+4m5qbfSPu0Jwhqf FTntSOdibNScROH7XO81+eljfVI0UAORzt86nq+cfpYPpM6LyWeeO+ULjAscgNtPmpp9 yO2ExRut0zz8Kb+OuBvoT8PVV7AW3/R/ezADLCSDE1uJAXwlpnSlle7YWXaKmIKFMzsX a1XCl2Lwa9nQC6ll2KaO1t/dUYU+6qK9orrh/6bHkToxmfL4sfU3HCJCqlLku7PUGxGe GRdA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1720468636; x=1721073436; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=CJnqQ8efHAnIR9B9EaA5p6X3tWdR/onOQ+bUH8a9TWA=; b=CzEAu1s5ojCcpn2P4h5nm3Cq5nbLHNJV/2wNReubsia91F1+lVnHzfXS17jggOV6fg fZpbw3BHCCM70MNseu9W7xAG5CgMBt62iNiVd2wdcpUrmhLii5xtY95da698VR07yLPC FB+gGVyFOJgmyFdAQp4T344IdFCMtijx74bE+uLmoufSO1rIB5c9r38GHgsP6o+ygH9m R9FYJsKlpUuESdRrXhs5znlOWjoFZb/UtuyIh6y4PDSVR4WjFuWMM01DmgaBsmal39dY P0IA/AOAC1O8rUEKgZOdEmL3qxSmYVN7heFdP7MrUwBrSWf1CxFzOHyeZhX1WyYJuKDj +HQQ== X-Gm-Message-State: AOJu0Yxnnb0+y0oL6gVEebN4vzyQlgB76dI6Ec8yz8pfCclMuZZP6YCO wFmW4dSLdNF0ZXKqAg8xUptDJ9QRqEVLU6wkYTdrzNZtSZW3nC58pD0ftW7pezrNha/NcJJd3b1 KGCQVyHAw73eIl4x/nnP47mSQwsWQNRgv X-Google-Smtp-Source: AGHT+IHYPvooasw9Ask6sptmQrCceQ9jynlLrjZZlU4Tk/9T+c2Lac7Z3nWbtbyZOf39m2DP7Y8AXOEo9fDSzNskZls= X-Received: by 2002:a05:6871:205:b0:25e:42e:f96 with SMTP id 586e51a60fabf-25eae88a802mr335976fac.27.1720468635753; Mon, 08 Jul 2024 12:57:15 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Ruben Morais Date: Mon, 8 Jul 2024 20:57:04 +0100 Message-ID: Subject: Re: Upgrading from v12.7 to v15.7 To: yserkfem@gmail.com Cc: pgsql-general@postgresql.org Content-Type: multipart/alternative; boundary="000000000000e1a9e7061cc1d1eb" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000e1a9e7061cc1d1eb Content-Type: text/plain; charset="UTF-8" Hi, Cstore -https://github.com/citusdata/cstore_fdw Oracle_fdw - https://github.com/laurenz/oracle_fdw/releases/tag/ORACLE_FDW_2_6_0 On Mon, Jul 8, 2024, 19:52 Yongye Serkfem wrote: > Hello Engineers, > After upgrading from v12.7 to v15.7, I ran the following command and got > this error message. > > postgres_upgrade_work_area]$ /usr/pgsql-15/bin/pg_upgrade \ > > --check \ > --old-datadir=/data/postgres12 \ > > --old-datadir=/data/postgres12 \ > > --new-datadir=/data/postgres \ > > --old-bindir=/usr/pgsql-12/bin \ > > --new-bindir=/usr/pgsql-15/bin \ > > --old-options '-c config_file=/data/postgres12/postgresql.conf' \ > > --new-options '-c config_file=/data/postgres/postgresql.conf' \ > > --old-port=5433 \ > > --new-port=5432 > Performing Consistency Checks on Old Live Server > ------------------------------------------------ > Checking cluster versions ok > Checking database user is the install user ok > Checking database connection settings ok > Checking for prepared transactions ok > Checking for system-defined composite types in user tables ok > Checking for reg* data types in user tables ok > Checking for contrib/isn with bigint-passing mismatch ok > Checking for user-defined encoding conversions ok > Checking for user-defined postfix operators ok > Checking for incompatible polymorphic functions ok > Checking for presence of required libraries fatal > > Your installation references loadable libraries that are missing from the > > new installation. You can add these libraries to the new installation, > or remove the functions using them from the old installation. A list of > problem libraries is in the file: > > /data/postgres/pg_upgrade_output.d/20240708T141557.291/loadable_libraries.txt > > Failure, exiting > > [postgres@AWPPLCOLEDBXL01 postgres_upgrade_work_area]$ ll > total 0 > [postgres@AWPPLCOLEDBXL01 postgres_upgrade_work_area]$ cat > /data/postgres/pg_upgrade_output.d/20240708T141557.291/loadable_libraries.txt > could not load library "$libdir/cstore_fdw": ERROR: could not access file > "$libdir/cstore_fdw": No such file or directory > In database: postgres > In database: logicole > could not load library "$libdir/oracle_fdw": ERROR: could not access file > "$libdir/oracle_fdw": No such file or directory > In database: postgres > In database: logicole > > Does anyone know where I can download rpm cstore_fdw and oracle_fdw. I > have searched and can't find the rpm for v15.7. > > I will greatly appreciate any help. > --000000000000e1a9e7061cc1d1eb Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Mon, Jul 8, 2024, 19:52 Yongye Serkfem <= ;yserkfem@gmail.com> wrote:
Hello Engineers,
=
After upgrading from v12.7 to v15.7, I ran the following command and g= ot this error message.

postgres_upgrade_work= _area]$ /usr/pgsql-15/bin/pg_upgrade \
> --check \
--old-datadir=3D/data/postgres12 \
> --old-datadir=3D/data/postgres12= \
> --new-datadir=3D/data/postgres \
> --old-bindir=3D/usr/pgs= ql-12/bin \
> --new-bindir=3D/usr/pgsql-15/bin \
> --old-option= s '-c config_file=3D/data/postgres12/postgresql.conf' \
> --n= ew-options '-c config_file=3D/data/postgres/postgresql.conf' \
&= gt; --old-port=3D5433 \
> --new-port=3D5432
Performing Consistency Checks on Old Live Server
------------------------------------------------
Checking cluster versions=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0 ok
Checking database user is the install user=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 ok Checking database connection settings=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0 ok
Checking for prepared transactions=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 ok
Checking for system-defined composite types in user tables=C2=A0 ok
Checking for reg* data types in user tables=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 ok
Checking for contrib/isn with bigint-passing mismatch=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0 ok
Checking for user-defined encoding conversions=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 ok
Checking for user-defined postfix operators=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 ok
Checking for incompatible polymorphic functions=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 ok
Checking for presence of required libraries=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 fatal

=C2=A0Your installation references loadable libraries that are missing = from the

new installation.=C2=A0 You can add these libraries to the new installation= ,
or remove the functions using them from the old installation.=C2=A0 A list = of
problem libraries is in the file:
=C2=A0=C2=A0=C2=A0 /data/postgres/pg_upgrade_output.d/20240708T141557.291/l= oadable_libraries.txt

=C2=A0Failure, exiting

[postgres@AWPPLCOLEDBXL01 postgres_upgrade_work_area]$ ll
total 0
[postgres@AWPPLCOLEDBXL01 postgres_upgrade_work_area]$ cat /data/postgres/p= g_upgrade_output.d/20240708T141557.291/loadable_libraries.txt
could not load library "$libdir/cstore_fdw": ERROR:=C2=A0 could n= ot access file "$libdir/cstore_fdw": No such file or directory In database: postgres
In database: logicole
could not load library "$libdir/oracle_fdw": ERROR:=C2=A0 could n= ot access file "$libdir/oracle_fdw": No such file or directory In database: postgres
In database: logicole

Does anyone know where I can download rpm cstor= e_fdw and oracle_fdw. I have searched and can't find the rpm for v15.7.= =C2=A0

I will greatly appreciate any help.

--000000000000e1a9e7061cc1d1eb--