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