RE: Dump and load - Mailing list pgsql-novice
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 <kim.heckler@nationwide.com>
Sent: Thursday, November 14, 2019 12:37 PM
To: pgsql-novice@postgresql.org
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?
| Kim M. Heckler Consultant, Infrastructure Eng Proud Nationwide Member Distributed Database Storage W 614-249-3014 C 740-816-0908 |
FORTUNE® and Time Inc. are not affiliated with, and do not endorse the products or services of, Nationwide Mutual Insurance Company. | |
|
|
Attachment
pgsql-novice by date: