pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedRolling forward to 10.1, new issue...
7+ messages / 4 participants
[nested] [flat]
* Rolling forward to 10.1, new issue...
@ 2018-01-11 17:27 Karl Denninger <karl@denninger.net>
0 siblings, 1 reply; 7+ messages in thread
From: Karl Denninger @ 2018-01-11 17:27 UTC (permalink / raw)
To: pgsql-admin
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.
I've got the contrib module loaded but the functions are not there. For
example:
pgsql=# select crypt('test', gen_salt('md5'));
ERROR: function gen_salt(unknown) does not exist
LINE 1: select crypt('test', gen_salt('md5'));
^
HINT: No function matches the given name and argument types. You might
need to add explicit type casts.
I shut down the server in question, went back and re-made the pgcrypto
contrib directory (it HAD been installed previously) and re-did the
install, then restarted the server -- no change. I've never seen this
problem before....
Not quite sure where to look next..... any ideas?
--
Karl Denninger
karl@denninger.net <mailto:karl@denninger.net>
/The Market Ticker/
/[S/MIME encrypted email preferred]/
Attachments:
smime.p7s (application/pkcs7-signature, 4.8K) download
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Rolling forward to 10.1, new issue...
@ 2018-01-11 17:48 Tom Lane <tgl@sss.pgh.pa.us>
parent: Karl Denninger <karl@denninger.net>
0 siblings, 2 replies; 7+ messages in thread
From: Tom Lane @ 2018-01-11 17:48 UTC (permalink / raw)
To: Karl Denninger <karl@denninger.net>; +Cc: pgsql-admin
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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Rolling forward to 10.1, new issue...
@ 2018-01-11 18:16 Karl Denninger <karl@denninger.net>
parent: Tom Lane <tgl@sss.pgh.pa.us>
1 sibling, 1 reply; 7+ messages in thread
From: Karl Denninger @ 2018-01-11 18:16 UTC (permalink / raw)
To: pgsql-admin
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 <mailto:karl@denninger.net>
/The Market Ticker/
/[S/MIME encrypted email preferred]/
Attachments:
smime.p7s (application/pkcs7-signature, 4.8K) download
^ permalink raw reply [nested|flat] 7+ messages in thread
* RE: Rolling forward to 10.1, new issue...
@ 2018-01-11 18:23 Karen Stone <kstone@eldocomp.com>
parent: Tom Lane <tgl@sss.pgh.pa.us>
1 sibling, 0 replies; 7+ messages in thread
From: Karen Stone @ 2018-01-11 18:23 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-admin
Can you please remove me from this list. Thanks!
Karen Stone| Technical Services| Eldorado |a Division of MphasiS
5353 North 16th Street, Suite 400, Phoenix, Arizona 85016-3228
Tel (928) 892 5735 | www.eldoinc.com | www.mphasis.com |kstone@eldocomp.com
-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Thursday, January 11, 2018 10:49 AM
To: Karl Denninger <karl@denninger.net>
Cc: pgsql-admin@postgresql.org
Subject: Re: Rolling forward to 10.1, new issue...
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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Rolling forward to 10.1, new issue...
@ 2018-01-12 18:46 Keith <keith@keithf4.com>
parent: Karl Denninger <karl@denninger.net>
0 siblings, 1 reply; 7+ messages in thread
From: Keith @ 2018-01-12 18:46 UTC (permalink / raw)
To: Karl Denninger <karl@denninger.net>; +Cc: 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> <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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Rolling forward to 10.1, new issue...
@ 2018-01-12 19:27 Karl Denninger <karl@denninger.net>
parent: Keith <keith@keithf4.com>
0 siblings, 1 reply; 7+ messages in thread
From: Karl Denninger @ 2018-01-12 19:27 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
On 1/12/2018 12:46, Keith wrote:
>
>
> On Thu, Jan 11, 2018 at 1:16 PM, Karl Denninger <karl@denninger.net
> <mailto:karl@denninger.net>> wrote:
>
> On 1/11/2018 11:48, Tom Lane wrote:
>
>> Karl Denninger <karl@denninger.net> <mailto: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 <mailto:karl@denninger.net>
> /The Market Ticker/
> /[S/MIME encrypted email preferred]/
>
>
Nope, it was originally installed into template1 and should have been
inherited.
Create extension worked but I have no idea why the pg_upgrade didn't
carry it forward -- I have used pg_upgrade before before (the
installation in question has been around for a long time) without
incident. The only "gotcha" I've run into with pg_upgrade before was
the moving of tsearch2 into the base which led me to have a bit of fun
with upgrading to 10.x.
I'll see if I can find a way to reproduce this if I can get the time to
spin up a copy of the 9.6 database (this particular installation is not
ridiculously large) from backups and run the upgrade again. I popped in
here because it was completely unexpected, given that the database in
question had previously been running under v9 and had stored passwords
encrypted with the functions in the table. As soon as it was upgraded
verification broke since the extension disappeared.
--
Karl Denninger
karl@denninger.net <mailto:karl@denninger.net>
/The Market Ticker/
/[S/MIME encrypted email preferred]/
Attachments:
smime.p7s (application/pkcs7-signature, 4.8K) download
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Rolling forward to 10.1, new issue...
@ 2018-01-12 20:20 Keith <keith@keithf4.com>
parent: Karl Denninger <karl@denninger.net>
0 siblings, 0 replies; 7+ messages in thread
From: Keith @ 2018-01-12 20:20 UTC (permalink / raw)
To: Karl Denninger <karl@denninger.net>; +Cc: pgsql-admin@lists.postgresql.org
On Fri, Jan 12, 2018 at 2:27 PM, Karl Denninger <karl@denninger.net> wrote:
> On 1/12/2018 12:46, Keith wrote:
>
>
>
> 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> <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]*
>>
>
> Nope, it was originally installed into template1 and should have been
> inherited.
>
Creating it in template1 does not automatically inherit it to all other
databases. That only causes it to be installed in databases created after
you installed it to template1.
> Create extension worked but I have no idea why the pg_upgrade didn't carry
> it forward -- I have used pg_upgrade before before (the installation in
> question has been around for a long time) without incident. The only
> "gotcha" I've run into with pg_upgrade before was the moving of tsearch2
> into the base which led me to have a bit of fun with upgrading to 10.x.
>
> I'll see if I can find a way to reproduce this if I can get the time to
> spin up a copy of the 9.6 database (this particular installation is not
> ridiculously large) from backups and run the upgrade again. I popped in
> here because it was completely unexpected, given that the database in
> question had previously been running under v9 and had stored passwords
> encrypted with the functions in the table. As soon as it was upgraded
> verification broke since the extension disappeared.
>
> --
> Karl Denninger
> karl@denninger.net
> *The Market Ticker*
> *[S/MIME encrypted email preferred]*
>
Yeah, I think you're going to have to get a repeatable set of steps here.
Could very well be a problem, but without that, it's very hard to figure
out what went wrong here.
Keith
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2018-01-12 20:20 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2018-01-11 17:27 Rolling forward to 10.1, new issue... Karl Denninger <karl@denninger.net>
2018-01-11 17:48 ` Tom Lane <tgl@sss.pgh.pa.us>
2018-01-11 18:16 ` Karl Denninger <karl@denninger.net>
2018-01-12 18:46 ` Keith <keith@keithf4.com>
2018-01-12 19:27 ` Karl Denninger <karl@denninger.net>
2018-01-12 20:20 ` Keith <keith@keithf4.com>
2018-01-11 18:23 ` Karen Stone <kstone@eldocomp.com>
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