public inbox for [email protected]  

help / color / mirror / Atom feed

From: Sameer Malve <[email protected]>
To: Zaid Shabbir <[email protected]>
Cc: [email protected]
Cc: [email protected]
Subject: Re: RHEL certified repo provided PostgreSQL Major Version Upgrade.
Date: Tue, 8 Oct 2024 16:03:17 +0530
Message-ID: <CAEGp0dhrCdbObZ4OQy_swTdpUEBFAHe-Hf1HdAHCMcYVTaJ2hA@mail.gmail.com> (raw)
In-Reply-To: <CABCJe_XHiuK07Q1oYyq1ZjGMUrCkvonDSfzL0nY3RqSP-U72vw@mail.gmail.com>
References: <CAEGp0dgUL=j4ULDfGz4j=kbv2sAzP5dmp=Wem7cOknq8gyge4Q@mail.gmail.com>
	<CABCJe_XHiuK07Q1oYyq1ZjGMUrCkvonDSfzL0nY3RqSP-U72vw@mail.gmail.com>

Hi Zaid,

Does this Upgrade command stand true in case of postgres upgrade between
community (PGDG) to RHEL?

Regards,
Sameer Malve

On Tue, Oct 8, 2024 at 3:24 PM Zaid Shabbir <[email protected]> wrote:

> Hello Sameer,
>
> For upgrade you can also use quick upgrade scripts
>
> /usr/pgsql-16/bin/postgresql-16-setup check_upgrade
>
> /usr/pgsql-16/bin/postgresql-16-setup upgrade
>
>
> Above commands are helpful to upgrade from 15 to 16, in case someone wants
> to upgrade from -2 older version then some minor adjustments required in
> setup script.
>
>
>
> Regards,
>
> Zaid
>
> On Tue, Oct 8, 2024 at 1:24 PM Sameer Malve <[email protected]> wrote:
>
>> Hi Team,
>>
>> We are trying to perform the Major version upgrade on RHEL 8 using
>> RHEL-certified repo `rhel-8-for-x86_64-appstream-rpms` from PG 15.6 to PG
>> 16.4 using `pg_upgrade` but we are facing the below issue.
>>
>> As the binaries are getting upgraded in-place `/usr/bin` hence while
>> performing pg_upgrade we are not getting the older binaries.
>>
>> pg_upgrade command is as follows.
>>
>> [2024-10-04 11:18:47]  $ /usr/bin/pg_upgrade -b /usr/bin/ -B /usr/bin/ -d
>>> /pgData/pgsql/15/data -D /pgData/pgsql/16/data -c
>>> [2024-10-04 11:19:19]
>>> [2024-10-04 11:19:19]  You must identify the directory where the old
>>> cluster binaries reside.
>>> [2024-10-04 11:19:19]  Please use the -b command-line option or the
>>> PGBINOLD environment variable.
>>> [2024-10-04 11:19:19]  Failure, exiting
>>>
>>
>>
>> Regards,
>> Sameer Malve
>>
>

view thread (13+ messages)  latest in thread

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], [email protected], [email protected]
  Subject: Re: RHEL certified repo provided PostgreSQL Major Version Upgrade.
  In-Reply-To: <CAEGp0dhrCdbObZ4OQy_swTdpUEBFAHe-Hf1HdAHCMcYVTaJ2hA@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