Thread: Upgrading from v12.7 to v15.7

Upgrading from v12.7 to v15.7

From
Yongye Serkfem
Date:
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.

Re: Upgrading from v12.7 to v15.7

From
Ruben Morais
Date:

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 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.