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...  (Karl Denninger <karl@denninger.net>)
Список pgsql-admin
Дерево обсуждения


On Thu, Jan 11, 2018 at 1:16 PM, Karl Denninger <karl@denninger.net> wrote:

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
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@denninger.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

В списке pgsql-admin по дате отправления:

Предыдущее
От: Ryan Odening
Дата:
Сообщение: Re: Please remove me from the mailing list....
Следующее
От: Rui DeSousa
Дата:
Сообщение: Re: Broken replication in 3 node setup, master halt,standby 1 promoted, standby 2 - replication not working