From: Gary Stainburn <gary.stainburn@ringways.co.uk>
Organization: Ringways Garages Ltd
To: pgsql-admin@lists.postgresql.org
Subject: Re: upgrade from FC9 / PG8.3 to C7 / PG 9.6 - utf8
Date: Mon, 21 Jan 2019 15:03:23 +0000
User-Agent: KMail/1.9.10
References: <201901181429.51278.gary.stainburn@ringways.co.uk>
 <6ea28c2f-9916-1f74-9262-9448e12c62a9@gmail.com>
 <201901181642.45463.gary.stainburn@ringways.co.uk>
In-Reply-To: <201901181642.45463.gary.stainburn@ringways.co.uk>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="utf-8"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <201901211503.23073.gary.stainburn@ringways.co.uk>
Precedence: bulk

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