Re: pg_dump / pg_restore version confusion

On 7/29/20 3:53 AM, Zwettler Markus (OIZ) wrote:
> Hi,
> 
> An external supplier had a postgres v9.5 database which he dumped with a 
> pg_dump v12 client in custom format using PgAdmin4.
> 
> Would a pg_restore with a v12 client into a postgres v9.6 database work 
> and be officially supported?

The best that could be said is it may work.

Officially supported :

https://www.postgresql.org/docs/12/app-pgdump.html

"Because pg_dump is used to transfer data to newer versions of 
PostgreSQL, the output of pg_dump can be expected to load into 
PostgreSQL server versions newer than pg_dump's version. pg_dump can 
also dump from PostgreSQL servers older than its own version. 
(Currently, servers back to version 8.0 are supported.) However, pg_dump 
cannot dump from PostgreSQL servers newer than its own major version; it 
will refuse to even try, rather than risk making an invalid dump. Also, 
it is not guaranteed that pg_dump's output can be loaded into a server 
of an older major version — not even if the dump was taken from a server 
of that version. Loading a dump file into an older server may require 
manual editing of the dump file to remove syntax not understood by the 
older server. "




> 
> Thanks, Markus
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com