| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Zwettler Markus (OIZ)" <Markus(dot)Zwettler(at)zuerich(dot)ch> |
| Cc: | Bruce Momjian <bruce(at)momjian(dot)us>, pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: AW: pg_dump / pg_restore version confusion |
| Date: | 2020-07-29 14:15:39 |
| Message-ID: | 1314762.1596032139@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
"Zwettler Markus (OIZ)" <Markus(dot)Zwettler(at)zuerich(dot)ch> writes:
> And I can also do this restore:
> <quote>
> Would a pg_restore with a v12 client into a postgres v9.6 database work and be officially supported?
> </quote>
It might work, but it's not completely guaranteed. Sometimes a new
pg_dump will use DDL syntax that doesn't exist in older versions,
even to describe constructs that do exist in older versions. This
isn't really common though.
I'd say try it and see. If the dump loads into 9.6 without errors then
it's probably fine (but you could dump again, with the same pg_dump
version, and diff the outputs to confirm).
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Daniel Westermann (DWE) | 2020-07-29 14:49:02 | Re: Out of memory with "create extension postgis" |
| Previous Message | Adrian Klaver | 2020-07-29 13:55:52 | Re: AW: pg_dump / pg_restore version confusion |