| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Willy-Bas Loos <willybas(at)gmail(dot)com> |
| Cc: | Melvin Davidson <melvin6925(at)gmail(dot)com>, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: migrating data from an old postgres version |
| Date: | 2016-07-15 15:07:18 |
| Message-ID: | 6075.1468595238@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Willy-Bas Loos <willybas(at)gmail(dot)com> 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Willy-Bas Loos | 2016-07-15 15:32:59 | Re: migrating data from an old postgres version |
| Previous Message | Adrian Klaver | 2016-07-15 15:01:39 | Re: Cascade streaming replication + wal_files - Pgsql 9.2 |