This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

pgcrypto.control

Trying to install File Reporter 3.6. Using PostgreSQL 10 on SLES12sp3 server. Database configuration wizard is throwing this error when doing the database schema piece:
Error: 58P01: could not open the extension control file"/usr/share/postgresql10/extension/pgcrypto.control": No such file or directory. The path exists, the file does not. The File Reporter documentation for PostgreSQL points you to the PostgreSQL site and you have to figure it out on your own. I saw no mention of installing a pgcrypto.control extension.
  • 0
    On 2/8/2019 1:56 PM, afirizarry uw wrote:
    >
    > Trying to install File Reporter 3.6. Using PostgreSQL 10 on SLES12sp3
    > server. Database configuration wizard is throwing this error when doing
    > the database schema piece:
    > Error: 58P01: could not open the extension control
    > file"/usr/share/postgresql10/extension/pgcrypto.control": No such file
    > or directory. The path exists, the file does not. The File Reporter
    > documentation for PostgreSQL points you to the PostgreSQL site and you
    > have to figure it out on your own. I saw no mention of installing a
    > pgcrypto.control extension.
    >
    >

    pgcrypto is packaged with most PostgreSQL installers; which package and
    distribution did you install?

    -- NFMS Support Team
  • 0 in reply to 
    Following this documentation: https://zypp.postgresql.org/howtozypp.php
    Ran the following commands:
    zypper addrepo https://download.postgresql.org/pub/repos/zypp/repo/pgdg-sles-10.repo
    zypper refresh
    zypper install SUSEConnect
    SUSEConnect -p PackageHub/12.3/x86_64
    SUSEConnect -p sle-sdk/12.3/x86_64
    zypper install postgresql10-server

    Just rebuilt the server again this time with SLES12sp3. Ran through the same steps and still no pgcrypto.control file in /usr/share/postgresql10/extensions
  • 0 in reply to 

    You've more than likely solved this by now, but anyone else looking, you need to install postgresql10-contrib.

    I searched my software repositories using YAST for the rpm that provided pgcrypto, it's included in the SLES 12 media repository.