Re: AW: pg_dump / pg_restore version confusion - Mailing list pgsql-general

"Zwettler Markus (OIZ)" <Markus.Zwettler@zuerich.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