Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Postgres missing pgcrypt ability?

I'm trying to run a Java Jetty application and I keep seeing this error:

Caused by: 
org.postgresql.util.PSQLException: ERROR: function crypt(character varying, character) does not exist|  Hint: No function matches the given name and argument types. You might need to add explicit type casts.|  Where: PL/pgSQL function 

Does anyone recognize this or how to solve the issue? I thought pgcrypt was prebundled in Postgres 9.1.x?

I currently run Mac OSX Lion 10.7 and installed Postgres using brew "brew install postgres".

like image 501
kidcapital Avatar asked Jun 20 '12 04:06

kidcapital


1 Answers

I just had to enable pgcrypto; Just ran from the CLI:

CREATE EXTENSION pgcrypto;

For mac users I recommend reading more about it on brew:

brew info postgres

like image 107
kidcapital Avatar answered Sep 19 '22 17:09

kidcapital