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
