Re: Upgrading 6 versions between 2 systems

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Rich Shepard <rshepard(at)appl-ecosys(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Upgrading 6 versions between 2 systems
Date: 2026-09-14 22:23:07
Message-ID: 45ef2a8b-7a33-4274-9d88-a4abbbaf60cb@aklaver.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 9/14/26 2:58 PM, Rich Shepard wrote:
> On Mon, 14 Sep 2026, Adrian Klaver wrote:
>
>> Since you are transferring the data as text that should not be a problem.
>> Just point the newer version of pg_dumpall, I assume the one on the
>> Slackware 15 host, at the older version Postgres server.
>
> Adrian,
>
> Hadn't thought I could do that. But, why not if I use the
> servername:/directory?

Not sure what servername:/directory means?

As example, assuming Postgres 12.7 is running on machine at address
192.168.0.1.

pg_dumpall -h 192.168.0.1 -U some_user -f db_cluster.sql

This would be run from the second machine that has Postgres 18.6.

>
> Thanks,
>
> Rich
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Brajendra Pratap Singh 2026-09-15 01:38:35 pg_upgrade --link
Previous Message Rich Shepard 2026-09-14 21:58:28 Re: Upgrading 6 versions between 2 systems