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