Re: Rolling forward to 10.1, new issue...
От | Keith |
---|---|
Тема | Re: Rolling forward to 10.1, new issue... |
Дата | |
Msg-id | CAHw75vt+dNL_cqr2aKgCd-S_+PWnucAL4VZOSkT+p7E6SpZsqQ@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: Rolling forward to 10.1, new issue... (Karl Denninger <karl@denninger.net>) |
Ответы |
Re: Rolling forward to 10.1, new issue...
|
Список | pgsql-admin |
On Thu, Jan 11, 2018 at 1:16 PM, Karl Denninger <karl@denninger.net> wrote:
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?On 1/11/2018 11:48, Tom Lane wrote:
Karl Denninger <karl@denninger.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
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.)
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
В списке pgsql-admin по дате отправления: