Re: Upgrade problem - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Upgrade problem
Date
Msg-id 97dedf73-691a-f1bc-9bb3-e807841fb251@aklaver.com
Whole thread Raw
In response to Re: Upgrade problem  (Graeme <graeme@gemmill.name>)
List 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.klaver@aklaver.com




pgsql-general by date:

Previous
From: Ray O'Donnell
Date:
Subject: Re: Upgrade problem
Next
From: "Johnson, Bruce E - (bjohnson)"
Date:
Subject: Granting privileges to a schema to a role