Search Postgresql Archives

Re: migrating data from an old postgres version

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux