| From: | Karl Denninger <karl(at)denninger(dot)net> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Rolling forward to 10.1, new issue... |
| Date: | 2018-01-11 17:27:18 |
| Message-ID: | 77e478d5-2d89-2d7d-18af-0a786070b88a@denninger.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)denninger(dot)net <mailto:karl(at)denninger(dot)net>
/The Market Ticker/
/[S/MIME encrypted email preferred]/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2018-01-11 17:39:35 | Re: Using 9.6 client with 10.0 server |
| Previous Message | Magnus Hagander | 2018-01-11 17:25:54 | Re: pg_receivexlog only captures WAL data, not *.backup? |