Re: Dump and load

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Heckler, Kim M" <kim(dot)heckler(at)nationwide(dot)com>
Cc: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Dump and load
Date: 2019-11-14 20:09:11
Message-ID: 9785.1573762151@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

"Heckler, Kim M" <kim(dot)heckler(at)nationwide(dot)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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Stephen Froehlich 2019-11-14 20:13:24 RE: Dump and load
Previous Message Andreas Kretschmer 2019-11-14 19:53:49 Re: Dump and load