From: Rich Shepard <rshepard@appl-ecosys.com>
To: pgsql-general@postgresql.org
Subject: Re: Upgrading 6 versions between 2 systems
Date: Mon, 14 Sep 2026 14:39:00 -0700 (PDT)
Message-ID: <6d2b5aa-8346-19ee-e12b-7abe23d7f685@appl-ecosys.com> (raw)
In-Reply-To: <201090.1789418600@sss.pgh.pa.us>
References: <deee7dc-8e5e-cbba-aa3-2141e5d15c6a@appl-ecosys.com>
<201090.1789418600@sss.pgh.pa.us>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-general@postgresql.org
Cc: rshepard@appl-ecosys.com
Subject: Re: Upgrading 6 versions between 2 systems
In-Reply-To: <6d2b5aa-8346-19ee-e12b-7abe23d7f685@appl-ecosys.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox