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 1sQtUj-00CDSi-Mv for pgsql-general@arkaria.postgresql.org; Mon, 08 Jul 2024 18:53:49 +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 1sQtTj-0087EZ-B2 for pgsql-general@arkaria.postgresql.org; Mon, 08 Jul 2024 18:52:47 +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 1sQtTi-0087ER-Q8 for pgsql-general@lists.postgresql.org; Mon, 08 Jul 2024 18:52:46 +0000 Received: from mail-ed1-x52a.google.com ([2a00:1450:4864:20::52a]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sQtTf-0014lt-U9 for pgsql-general@postgresql.org; Mon, 08 Jul 2024 18:52:45 +0000 Received: by mail-ed1-x52a.google.com with SMTP id 4fb4d7f45d1cf-57cbc2a2496so4957352a12.0 for ; Mon, 08 Jul 2024 11:52:43 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1720464762; x=1721069562; darn=postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=f/+jiv1ddvAqYl5vzQOmcr/OAmV8MhDw/94PeAFOE4k=; b=NOAgFsRJf3ATMnyATyd9NWncTp6xidwWPuvOb/X88pQLh4jxjaXN/zIpEy4n4GbyfL W/RvA+Gje9r/FJJYB54VmT5alWVdGnVl4nSQDkmpYcMMn4wwcHsBzWmoFC1TniBVy38E /DGFaJnzqolT++8dhVy3xEUNc+fRUsXav46uYEyiLFWhQYbzgjLCs4EcntSBRU9nXlAn s0gQpoiG51+zzI7pohOL2pbFjAYBqvLYakgyf+WteRQkO+jujzdy2jfHluFOpIdr1Dfz aQQs/Wtu22VrlRbwieWavZwvVwA26YfKh4znmu8aKKI/7GwdNNxny5N7+cT1+P/PiUb+ QvgQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1720464762; x=1721069562; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=f/+jiv1ddvAqYl5vzQOmcr/OAmV8MhDw/94PeAFOE4k=; b=u0SEKQy043e8OgyAXoX0JY/J5e124eTmtNhikkaZ/pk4k7wY/24D6rcA8j/qUvjQqD LqKciY3DXyhjWr2Yod2zbnYkM5tSAlOyNHKfzUNRiwnca/jY+DGlukqpCXC22CFjCt8p X1kqRL6kuNQtQd9z+lRLxpvNsjQJdw5laCZO3F0lAC4d7Aq3NtJqVOLPvSt7UI3z4a0L qn5V8qqL7RUVc1w/Ng6KoGnTZhQ9CSWzwY0XtIJIWJCoo9bH/6keRvwYkL4c+t+kOWE2 hvJRzvD0DGaRWGTvMa3kuaGq6XtCod632jF3iBhabsquOLV5g3YYkpT5UTllgO+upaqG Rlcw== X-Gm-Message-State: AOJu0Yzi5Cq9uS+9Ilvk5N26d50IdgjUy00O+A+ZCq15sPoG+HIZydEd xOKO7VydVVV200OP1FVJ0tbgpOrhwNFwubDSq4CUAtdLUJ8fyLwPQQisSjoYJ/9zbInr15To++Y jXAJUbau/tW+K4ozJG3iDxi1zSZILHB66PbM= X-Google-Smtp-Source: AGHT+IG4GEiMpKJ8LayEFiQJBgXk2jj+lnfPGtvdjzsTrJUBOSNxijlQm+zweeTzUAzG1LuP1AfCrjqsrpE5bN8lrRc= X-Received: by 2002:a05:6402:13c9:b0:58f:9874:ada7 with SMTP id 4fb4d7f45d1cf-594bcba65e5mr435709a12.39.1720464761840; Mon, 08 Jul 2024 11:52:41 -0700 (PDT) MIME-Version: 1.0 From: Yongye Serkfem Date: Mon, 8 Jul 2024 14:52:30 -0400 Message-ID: Subject: Upgrading from v12.7 to v15.7 To: pgsql-general Content-Type: multipart/alternative; boundary="000000000000fa6dc8061cc0eaea" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000fa6dc8061cc0eaea Content-Type: text/plain; charset="UTF-8" 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. --000000000000fa6dc8061cc0eaea Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
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=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.

--000000000000fa6dc8061cc0eaea--