Re: Upgrading 6 versions between 2 systems

On 9/14/26 2:39 PM, Rich Shepard wrote:
> On Mon, 14 Sep 2026, Tom Lane wrote:
>
>> You could, but better practice is to use pg_dump[all] from the newer
>> version to take a dump from the old server.
>
> Tom,
>
> I know that's the way it's normally done, but the two versions are on
> different LAN hosts and each runs a different Slackware version (14.2 with
> the current data) and verson 15.0 on a different host.

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.

>
>> Keep in mind also that 6 years is a lot of time for things to change.
>> I expect your dump will probably load okay, but test your application
>> for compatibility.
>
> My databases are small, most for specific projects. I'll dump each database
> separately rather than the whole cluster. That way I can see if a problem
> shows up.
>
> Thanks,
>
> Rich
>
>

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