Justin Pryzby <pry...@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


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to