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
[email protected]
