I'm in the process of creating a postgres database for production in CentOS 7. So I already installed (yum install postgresql10-server postgresql10 after adding the repos of course) and configured postgres 10. However, in my scripts I need to install pgcrypto extension and I haven't successfully install it. This is what I've done so far:
- the first error I got was saying that the
/usr/pgsql-10/share/extension/pgcrypto.controlfiles does not exist. Googling I realized that I have to install
postgres-contribpackage, which I did and then restarted postgres service, but the error continues due to the fact that the extensions were installed into
/usr/share/pgsql/extension, so I copied the extension files from they were installed to they were expected and then
appears this message
"ERROR: could not access file "$libdir/pgcrypto": No such file or directory"
Googling again I found that maybe I need to give another option, so I ran
CREATE EXTENSION pgcrypto FROM unpackaged;then
the error message now is
ERROR: function digest(text, text) does not exist
And I'm stuck and without any idea what to do next. Is anybody else using this extension in postgres 10 on Linux?, if so, how did you create the extension?
Version info: PostgreSQL 10.1 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-16), 64-bit