Re: Dump and load

Tom Lane <[email protected]> Thu, 14 Nov 2019 15:09:11 -0500
Newsgroups gmane.comp.db.postgresql.novice
Message-ID <[email protected]>
"Heckler, Kim M" <[email protected]> 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