Re: upgrade from FC9 / PG8.3 to C7 / PG 9.6 - utf8 - Mailing list pgsql-admin

On Monday 21 January 2019 15:03:23 Gary Stainburn wrote:
> 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=#


Sory folks, just found the answer.  I need to run 

create extension pgcrypto;

in each of my databases