Justin Pryzby <pryzby@telsasoft.com> writes:
> When doing a dump+restore upgrade, it's commonly recommended to use the later
> version of pg_restore:
> https://www.postgresql.org/docs/current/static/upgrading.html
> "It is recommended that you use the pg_dump and pg_dumpall programs from the
> newer version of PostgreSQL, to take advantage of enhancements that might have
> been made in these programs. Current releases of the dump programs can read
> data from any server version back to 7.0."
That says to use the pg_dump version *corresponding to the destination
server version*, not the latest version you can find anywhere.
No version of pg_dump has ever promised that its output would load
perfectly cleanly into lower-version destination servers, and that's
not a set of new compatibility constraints that I'd want to take on.
regards, tom lane