From: | Gary Stainburn <gary(dot)stainburn(at)ringways(dot)co(dot)uk> |
---|---|
To: | pgsql-admin(at)lists(dot)postgresql(dot)org |
Subject: | Re: upgrade from FC9 / PG8.3 to C7 / PG 9.6 - utf8 |
Date: | 2019-01-18 16:42:45 |
Message-ID: | 201901181642.45463.gary.stainburn@ringways.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On Friday 18 January 2019 16:23:25 Ron wrote:
> 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.
My data is nowhere near that scale. Mine took less than 40 minutes to run
pg_dumpall even using thr 8.3 pg_dumpall.
I have just had a look at the output from the 10.6 import and I am seeing a
large number of errors like:
psql:2019-01-18_1556.sql:8918192: ERROR: could not access
file "$libdir/pgcrypto": No such file or directory
psql:2019-01-18_1556.sql:8918195: ERROR: function
public.pgp_sym_encrypt(text, text, text) does not exist
Anyone know why I'm getting this and what I need to do to fix it? I wasn't
getting this (AFAIK) when importing to 9.6
From | Date | Subject | |
---|---|---|---|
Next Message | Horst Düster | 2019-01-21 10:18:37 | Huge table pg_shdepend |
Previous Message | Ron | 2019-01-18 16:23:25 | Re: upgrade from FC9 / PG8.3 to C7 / PG 9.6 - utf8 |