From: Gary Stainburn <gary.stainburn@ringways.co.uk>
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
Message-ID: <201901211503.23073.gary.stainburn@ringways.co.uk> (raw)
In-Reply-To: <201901181642.45463.gary.stainburn@ringways.co.uk>
References: <201901181429.51278.gary.stainburn@ringways.co.uk>
<6ea28c2f-9916-1f74-9262-9448e12c62a9@gmail.com>
<201901181642.45463.gary.stainburn@ringways.co.uk>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: gary.stainburn@ringways.co.uk, pgsql-admin@lists.postgresql.org
Subject: Re: upgrade from FC9 / PG8.3 to C7 / PG 9.6 - utf8
In-Reply-To: <201901211503.23073.gary.stainburn@ringways.co.uk>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox