RE: Dump and load
Stephen Froehlich <[email protected]> Thu, 14 Nov 2019 20:13:24 +0000
| Newsgroups | gmane.comp.db.postgresql.novice |
|---|---|
| Message-ID | <DM6PR06MB4889A97C1839A1FC7F7ACE53E5710@DM6PR06MB4889.namprd06.prod.outlook.com> |
Yes, absolutely ... or pg_restore can parallelize it better than psql if you have done a directory-based pg_dump (which can also parallelize). From: Heckler, Kim M <[email protected]> Sent: Thursday, November 14, 2019 12:37 PM To: [email protected] Subject: Dump and load 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? [Nationwide is on your side.] Kim M. Heckler Consultant, Infrastructure Eng Proud Nationwide Member Distributed Database Storage W 614-249-3014 C 740-816-0908 [email protected]<mailto:[email protected]> FORTUNE(r) and Time Inc. are not affiliated with, and do not endorse the products or services of, Nationwide Mutual Insurance Company.
image001.png
(image/png, 12.9 KB) - not displayed