Willy-Bas Loos <willybas@xxxxxxxxx> writes: > (the manual says:"It is recommended that you use the pg_dump and pg_dumpall > programs from the newer version of PostgreSQL") The reason for the manual's recommendation is that the newer version might contain bug fixes not present in the older one. But discounting that risk, a dump made by an older version of pg_dump usually should load into a newer server. We try *very* hard to avoid breaking syntaxes used by old pg_dump versions. The possibility of identifiers conflicting with new reserved words is a hazard of course, which is what "--quote-all-identifiers" was invented to address. But if you don't use that option, you're at risk for that regardless of whether you dumped with the older or new pg_dump. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
