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