From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Graeme <graeme(at)gemmill(dot)name>, pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Upgrade problem |
Date: | 2023-09-11 16:50:16 |
Message-ID: | 97dedf73-691a-f1bc-9bb3-e807841fb251@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 9/11/23 09:33, Graeme wrote:
> On 11/09/2023 17:13, Adrian Klaver wrote:
>> On 9/11/23 09:04, Graeme wrote:
>>> Preparing to upgrade my small cluster from Mageia 8/Pg 9 to Mageia
>>> 9/Pg 15. I'm at the point of running pg_upgrade but have received
>>> anerror message:
>>
>> You are going to have to be more specific on the Postgres version.
>> Prior to Postgres 10 major version changes where two digits. So for
>> Postgres 9.X.x that meant 9.0.x --> 9.6.x
> Don't have access to that version without re-booting; probably 9.5
In psql do:
select version();
>> Where are you running the pg_upgrade and what version of it are you
>> using?
>>
> pg_upgrade (PostgreSQL) 15.3
>
> I specified -B /usr/bin
Your Postgres 15 is on one machine(OS version) and your Postgres 9.X is
on another machine(OS version), how are reaching the Postgres installs
on both?
>>>
>>> Graeme Gemmill
>>
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Johnson, Bruce E - (bjohnson) | 2023-09-11 18:07:14 | Granting privileges to a schema to a role |
Previous Message | Ray O'Donnell | 2023-09-11 16:36:12 | Re: Upgrade problem |