Обсуждение: Dump and load

Am 14.11.19 um 20:36 schrieb Heckler, Kim M:
> Is it OK to use pg_dump from version 10.x, into a flat file, then use 
> psql to load that file into version 11.x?

yeah, should work, but it would be better to use the pg_dump from 
version 11 against the database version 10.


Regards, Andreas

-- 
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com

"Heckler, Kim M" <kim.heckler@nationwide.com> writes:
> Is it OK to use pg_dump from version 10.x, into a flat file, then use psql to load that file into version 11.x?

Sure.

(Typically, it's considered better practice to use the later version's
pg_dump for this.  But if that's not feasible, the older one's should
work.  We try not to break compatibility with old dump files.)

            regards, tom lane