From: Ron <ronljohnsonjr@gmail.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: upgrade from FC9 / PG8.3 to C7 / PG 9.6 - utf8
Date: Fri, 18 Jan 2019 10:23:25 -0600
Message-ID: <6ea28c2f-9916-1f74-9262-9448e12c62a9@gmail.com> (raw)
In-Reply-To: <201901181530.42190.gary.stainburn@ringways.co.uk>
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>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: ronljohnsonjr@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: upgrade from FC9 / PG8.3 to C7 / PG 9.6 - utf8
In-Reply-To: <6ea28c2f-9916-1f74-9262-9448e12c62a9@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox