On 1/18/19 9:30 AM, Gary Stainburn wrote:
[snip]
> I have done the import using the pg_dumpall done on the 8.3 system. From the
> comments earlier, would I be better off doing a pg_dumpall of the 8.3 system
> using the binarys from the 10.6 system?
How much data do you have, and how large of a window do you have to migrate
the data?
For example, we moved from 8.4 to 9.6 (that was frozen while 10 was still in
beta) and it would have taken almost five days to dump the data using the
single-threaded 8.4 pg_dump, and just as long to do a single-threaded restore.
OTOH, the elapsed time using the 9.6 pg_dump with 8 threads was 14 hours,
and the restore only 8.33 hours.
--
Angular momentum makes the world go 'round.