Re: Rolling forward to 10.1, new issue...

On Thu, Jan 11, 2018 at 1:16 PM, Karl Denninger <karl(at)denninger(dot)net> wrote:

> On 1/11/2018 11:48, Tom Lane wrote:
>
> Karl Denninger <karl(at)denninger(dot)net> <karl(at)denninger(dot)net> writes:
>
> I'm starting to roll forward to 10.1 in a couple of places and have run
> into a very odd problem -- the "pgcrypto" functions disappeared.
>
> Maybe you forgot "CREATE EXTENSION"?
>
> regards, tom lane
>
> Hmmm.... this was an upgrade from 9.6 and it *was* working there -- it's
> not a new install. Wouldn't that persist across the upgrade and, when the
> "gmake install" was done on the contrib module wouldn't it be picked up?
>
> I'll check that... it makes sense but I would have expected the
> roll-forward to work seamlessly (I used pg_upgrade, not a dump/restore.)
>
> --
> Karl Denninger
> karl(at)denninger(dot)net
> *The Market Ticker*
> *[S/MIME encrypted email preferred]*
>

That should persist yes. Did you install pgcrypto into a specific schema?
Check the search_path of the user that is trying to use pgcrypto.

Keith