public inbox for [email protected]
help / color / mirror / Atom feedFrom: Ruben Morais <[email protected]>
To: [email protected]
Cc: [email protected]
Subject: Re: Upgrading from v12.7 to v15.7
Date: Mon, 8 Jul 2024 20:57:04 +0100
Message-ID: <CAG8sLzv8=GUuB48PLWDmkUafqkw7=7yNpi6+ziL1P1Le0GxMSA@mail.gmail.com> (raw)
In-Reply-To: <CAAu_hGuXPns6ZVF_OSPN-SALPf_2m7EEr1jEh7ZiQU2u6vvR1A@mail.gmail.com>
References: <CAAu_hGuXPns6ZVF_OSPN-SALPf_2m7EEr1jEh7ZiQU2u6vvR1A@mail.gmail.com>
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 <[email protected]> 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.
>
view thread (2+ messages)
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: Upgrading from v12.7 to v15.7
In-Reply-To: <CAG8sLzv8=GUuB48PLWDmkUafqkw7=7yNpi6+ziL1P1Le0GxMSA@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox