Re: Upgrade problem - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Upgrade problem
Date
Msg-id d2854d83-b9d9-6964-1b4d-9a43381b65e8@aklaver.com
Whole thread Raw
In response to Re: Upgrade problem  (Graeme <graeme@gemmill.name>)
List pgsql-general
On 9/12/23 03:51, Graeme wrote:
> On 11/09/2023 17:04, Graeme wrote:
>>

>>
>> Ta
>>
>> Graeme Gemmill
> 
> Tom, Adrian, Ray: thanks for your comments. I see the problem now, 
> trying to gat a Mga8 module to link against Mga9 libraries. I suspecy a 
> carefully placed sym-link or two will sort the problem.
> 

I'm thinking you would be better off doing a pg_dumpall of the old 
cluster and psql <connection parameters> -f dump_file.sql on the new 
cluster per:

https://www.postgresql.org/docs/current/app-pg-dumpall.html

-- 
Adrian Klaver
adrian.klaver@aklaver.com




pgsql-general by date:

Previous
From: Graeme
Date:
Subject: Re: pg_update and encoding
Next
From: "Pete O'Such"
Date:
Subject: Unqualified relations in views