pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedUnable to upgrade from 12.7 to 15.2
4+ messages / 4 participants
[nested] [flat]
* Unable to upgrade from 12.7 to 15.2
@ 2023-04-20 10:14 Mahesh mana <maheshbabumms12@gmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: Mahesh mana @ 2023-04-20 10:14 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
Hello All,
we are facing below issues while upgrading the cluster from 12.7 to 15.2.
The OLD cluster contains cstore_fdw extension and we have installed
Citus(updated version of cstore_fdw) in postgresql 15.2 , we are not able
to proceed further as the below error is the blocker for the same, any help
regarding this will be much helpful.
TESTHOST:/tmp $ $NEW_PG_PATH/bin/pg_upgrade -b $OLD_PG_PATH/bin/ -B
$NEW_PG_PATH/bin/ -d $OLD_PG_DATA -D $NEW_PG_DATA --check
Performing Consistency Checks
-----------------------------
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
New cluster database "postgres" is not empty: found relation
"columnar_internal.options"
Failure, exiting
Thanks,
Mahesh.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Unable to upgrade from 12.7 to 15.2
@ 2023-04-20 13:12 Keith Fiske <keith.fiske@crunchydata.com>
parent: Mahesh mana <maheshbabumms12@gmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: Keith Fiske @ 2023-04-20 13:12 UTC (permalink / raw)
To: Mahesh mana <maheshbabumms12@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org
On Thu, Apr 20, 2023 at 6:14 AM Mahesh mana <maheshbabumms12@gmail.com>
wrote:
> Hello All,
>
> we are facing below issues while upgrading the cluster from 12.7 to 15.2.
>
> The OLD cluster contains cstore_fdw extension and we have installed
> Citus(updated version of cstore_fdw) in postgresql 15.2 , we are not able
> to proceed further as the below error is the blocker for the same, any help
> regarding this will be much helpful.
>
>
> TESTHOST:/tmp $ $NEW_PG_PATH/bin/pg_upgrade -b $OLD_PG_PATH/bin/ -B
> $NEW_PG_PATH/bin/ -d $OLD_PG_DATA -D $NEW_PG_DATA --check
> Performing Consistency Checks
> -----------------------------
> 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
>
> New cluster database "postgres" is not empty: found relation
> "columnar_internal.options"
> Failure, exiting
>
>
> Thanks,
> Mahesh.
>
I'd imagine you cannot have the extension pre-created in the new cluster
before the upgrade proceeds. Especially if it's a newer version. You may
have to do the upgrade with the old version of the extension installed and
then update to the new version after the PG upgrade.
If you don't get any further responses on this list, it may be better to
try and contact Citus for further support or make an issue on their github
- https://github.com/citusdata/cstore_fdw/issues
--
Keith Fiske
Senior Database Engineer
Crunchy Data - http://crunchydata.com
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Unable to upgrade from 12.7 to 15.2
@ 2023-04-20 15:42 Benjamin Acquaye <benjaminacquaye2@gmail.com>
parent: Keith Fiske <keith.fiske@crunchydata.com>
0 siblings, 1 reply; 4+ messages in thread
From: Benjamin Acquaye @ 2023-04-20 15:42 UTC (permalink / raw)
To: Keith Fiske <keith.fiske@crunchydata.com>; +Cc: Mahesh mana <maheshbabumms12@gmail.com>; pgsql-admin@lists.postgresql.org
Keith, you are absolutely correct. Mahesh transfer all the extensions from
the old server to the new server before upgrading
On Thu, Apr 20, 2023 at 9:13 AM Keith Fiske <keith.fiske@crunchydata.com>
wrote:
>
>
> On Thu, Apr 20, 2023 at 6:14 AM Mahesh mana <maheshbabumms12@gmail.com>
> wrote:
>
>> Hello All,
>>
>> we are facing below issues while upgrading the cluster from 12.7 to 15.2.
>>
>> The OLD cluster contains cstore_fdw extension and we have installed
>> Citus(updated version of cstore_fdw) in postgresql 15.2 , we are not able
>> to proceed further as the below error is the blocker for the same, any help
>> regarding this will be much helpful.
>>
>>
>> TESTHOST:/tmp $ $NEW_PG_PATH/bin/pg_upgrade -b $OLD_PG_PATH/bin/ -B
>> $NEW_PG_PATH/bin/ -d $OLD_PG_DATA -D $NEW_PG_DATA --check
>> Performing Consistency Checks
>> -----------------------------
>> 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
>>
>> New cluster database "postgres" is not empty: found relation
>> "columnar_internal.options"
>> Failure, exiting
>>
>>
>> Thanks,
>> Mahesh.
>>
>
>
> I'd imagine you cannot have the extension pre-created in the new cluster
> before the upgrade proceeds. Especially if it's a newer version. You may
> have to do the upgrade with the old version of the extension installed and
> then update to the new version after the PG upgrade.
>
> If you don't get any further responses on this list, it may be better to
> try and contact Citus for further support or make an issue on their github
> - https://github.com/citusdata/cstore_fdw/issues
>
> --
> Keith Fiske
> Senior Database Engineer
> Crunchy Data - http://crunchydata.com
>
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Unable to upgrade from 12.7 to 15.2
@ 2023-04-28 20:06 Bruce Momjian <bruce@momjian.us>
parent: Benjamin Acquaye <benjaminacquaye2@gmail.com>
0 siblings, 0 replies; 4+ messages in thread
From: Bruce Momjian @ 2023-04-28 20:06 UTC (permalink / raw)
To: Benjamin Acquaye <benjaminacquaye2@gmail.com>; +Cc: Keith Fiske <keith.fiske@crunchydata.com>; Mahesh mana <maheshbabumms12@gmail.com>; pgsql-admin@lists.postgresql.org
On Thu, Apr 20, 2023 at 11:42:58AM -0400, Benjamin Acquaye wrote:
> Keith, you are absolutely correct. Mahesh transfer all the extensions from the
> old server to the new server before upgrading
Yes, you have to _install_ the extensions in the new cluster at the
operating system level only, nothing more.
--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EDB https://enterprisedb.com
Embrace your flaws. They make you human, rather than perfect,
which you will never be.
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2023-04-28 20:06 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-04-20 10:14 Unable to upgrade from 12.7 to 15.2 Mahesh mana <maheshbabumms12@gmail.com>
2023-04-20 13:12 ` Keith Fiske <keith.fiske@crunchydata.com>
2023-04-20 15:42 ` Benjamin Acquaye <benjaminacquaye2@gmail.com>
2023-04-28 20:06 ` Bruce Momjian <bruce@momjian.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox