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-21 15:03:23 |
Message-ID: | 201901211503.23073.gary.stainburn@ringways.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On Friday 18 January 2019 16:42:45 Gary Stainburn wrote:
> 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
I found that I was getting this error because I had missed out installing the
postgresql10-contrib-10.6-1PGDG.rhel7.x86_64 RPM.
After doing this the install worked perfectly. However, when I try to use the
crypt() function I get the following error. I can't see what I've missed
users=# select crypt('password','myhash');
ERROR: function crypt(unknown, unknown) does not exist
LINE 1: select crypt('password','myhash');
^
HINT: No function matches the given name and argument types. You might need
to add explicit type casts.
users=#
I've got the following RPM's installed:
postgresql10-libs-10.6-1PGDG.rhel7.x86_64
postgresql10-contrib-10.6-1PGDG.rhel7.x86_64
postgresql10-10.6-1PGDG.rhel7.x86_64
postgresql10-server-10.6-1PGDG.rhel7.x86_64
From | Date | Subject | |
---|---|---|---|
Next Message | Gary Stainburn | 2019-01-21 15:06:19 | Re: upgrade from FC9 / PG8.3 to C7 / PG 9.6 - utf8 |
Previous Message | Shreeyansh Dba | 2019-01-21 14:23:00 | Re: Calculation of db size |