Date: Mon, 14 Sep 2026 14:39:00 -0700 (PDT)
From: Rich Shepard <rshepard@appl-ecosys.com>
To: pgsql-general@postgresql.org
Subject: Re: Upgrading 6 versions between 2 systems
In-Reply-To: <201090.1789418600@sss.pgh.pa.us>
Message-ID: <6d2b5aa-8346-19ee-e12b-7abe23d7f685@appl-ecosys.com>
References: <deee7dc-8e5e-cbba-aa3-2141e5d15c6a@appl-ecosys.com>
 <201090.1789418600@sss.pgh.pa.us>
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII; format=flowed
Archived-At: 
 <https://www.postgresql.org/message-id/6d2b5aa-8346-19ee-e12b-7abe23d7f685%40appl-ecosys.com>
Precedence: bulk

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.

> 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