Package Architecture Version Repository Size Last metadata expiration check: 0:02:07 ago on Wed 02:37:38 UTC. # I think this should install them explicitly from the PostgreSQL repo Uninstall all things related to PostgreSQL, and delete those files you copied or linked and run this # Adds the PostgreSQL repo What you probably want to do is install from the CentOS repos. You're installing the -contrib from the CentOS repos.You're installing the PostgreSQL from the PostgreSQL repos.Moving them in likely won't work either because if these are packaged by two separate entities they're likely built against different libraries. These are compile time variables and they should be the same. If that's not set to /usr/share/pgsql/extension then likely your postgresql-contrib was packaged by someone different than your copy of postgresql. You need to check what SHAREDIR is set to with pg_config -sharedir. PostgreSQL will create the extension using details from the file SHAREDIR/extension/extension_ntrol. Is anybody else using this extension in postgres 10 on Linux?, if so, how did you create the extension? Googling again I found that maybe I need to give another option, so I ran CREATE EXTENSION pgcrypto FROM unpackaged thenĮRROR: function digest(text, text) does not existĪnd I'm stuck and without any idea what to do next.

'ERROR: could not access file '$libdir/pgcrypto': No such file or directory' Googling I realized that I have to install postgres-contrib package, 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 the first error I got was saying that the /usr/pgsql-10/share/extension/ntrol files does not exist.However, in my scripts I need to install pgcrypto extension and I haven't successfully install it. So I already installed (yum install postgresql10-server postgresql10 after adding the repos of course) and configured postgres 10. I'm in the process of creating a postgres database for production in CentOS 7.

Centos install postgres