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