Subject: Re: upgrade from FC9 / PG8.3 to C7 / PG 9.6 - utf8
To: pgsql-admin@lists.postgresql.org
References: <201901181429.51278.gary.stainburn@ringways.co.uk>
 <201901181508.26233.gary.stainburn@ringways.co.uk>
 <8c6bfd45-8aa5-b966-ce29-ac65b7b525b3@matrix.gatewaynet.com>
 <201901181530.42190.gary.stainburn@ringways.co.uk>
From: Ron <ronljohnsonjr@gmail.com>
Message-ID: <6ea28c2f-9916-1f74-9262-9448e12c62a9@gmail.com>
Date: Fri, 18 Jan 2019 10:23:25 -0600
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101
 Thunderbird/60.2.1
MIME-Version: 1.0
In-Reply-To: <201901181530.42190.gary.stainburn@ringways.co.uk>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit
Content-Language: en-US
Precedence: bulk

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.