| 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-12 14:57:33 |
| Message-ID: | d2854d83-b9d9-6964-1b4d-9a43381b65e8@aklaver.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pete O'Such | 2023-09-13 05:58:28 | Unqualified relations in views |
| Previous Message | Graeme | 2023-09-12 14:56:46 | Re: pg_update and encoding |